MySQL upgrade and crash table problem

Sure bila dengar ni mesti risau giler..Aku dapat problem ni masa MailWatch aku problem dan sebabkan MailScanner takleh start. Selain tu, kerja upgrade ni perkara penting kena lakukan bagi menjaga operasi yang baik mysql server anda...tapi baca dulu apa patch dibuat pada version tersebut sekiranya melibatkan database yang besar.
-------------------------------------------------------------------------------------------
OS : RHEL 5 & CentOS 5.x

-------------------------------------------------------------------------------------------
Isu # 1 : Upgrade MySQL

Caranya :
1) # yum update mysql

2) Dah upgrade mysql lepas tu..
# mysql_upgrade -u root -p

OUTPUT : (lebih kurang berikut)
forum.phpbb_posts_text                             OK
forum.phpbb_privmsgs                               OK
forum.phpbb_privmsgs_text                          OK
forum.phpbb_ranks                                  OK
forum.phpbb_search_results                         OK
forum.phpbb_search_wordlist                        OK
forum.phpbb_search_wordmatch                       OK
forum.phpbb_sessions                               OK
forum.phpbb_sessions_keys                          OK
forum.phpbb_smilies                                OK
forum.phpbb_themes                                 OK
Running 'mysql_fix_privilege_tables'...
OK

3) Lakukan command tersebut setiap kali menjalankan kerja upgrade MYSQL.
Pada asasnya setiap kali run mysql_upgrade tu sebenarnya command berikut akan trigger :
mysqlcheck --all-databases --check-upgrade --auto-repair
mysql < fix_priv_tables
------------------------------------------------------------------------------


Isu # 2 : MySQL crash pada MailWatch

1) Terima error message berikut :
Table './mailscanner/maillog' is marked as crashed and should be repaired

2) # mysql -u root -p
mysql > REPAIR TABLE maillog USE_FRM;
mysql > exit;

3) Check web MailWatch dah kembali normal..so command REPAIR TABLE boleh digunakan sekiranya ada crash table.

-------------------------------------------------------------------------------------------

Selamat mencuba!

~ Be a Creator Not a User ~
http://muzzotechspot.blogspot.com
http://muzzoshah.blogspot.com

Ulasan