Home > World Of ICT > Solved:Cannot load from mysql.proc. The table is probably corrupted

Solved:Cannot load from mysql.proc. The table is probably corrupted


Pagi ini udah siap-siap aja mau ngoding, eh terganjal dengan sebuah warning error dari server MySQL pada waktu mau membuat query baru di Navicat. Warningnya adalah sebagai berikut  Cannot load from mysql.proc. The table is probably corrupted,  disebutkan bahwa kemungkinan table mysql.proc corrupt, solusi repair table dan myisamchk juga tidak menggembirakan, berkat bantuan Embah Guugle, rupanya solusinya sederhana, cukup dengan melakukan upgrade :-D  (Ngek-Ngok).

BGP-UNILA-MORATEL# mysql_upgrade -u gigih -p
Enter password:
Looking for 'mysql' as: mysql
Looking for 'mysqlcheck' as: mysqlcheck
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
db_sda.bidangilmu                                  OK
db_sda.biodata                                     OK

db_sda.check_tahun                                 OK
db_sda.counter                                     OK
db_sda.fakultas                                    OK
db_sda.fasilitas                                   OK
db_sda.golkat                                      OK
db_sda.jabatan                                     OK
db_sda.jurusan                                     OK
db_sda.laboratorium                                OK
db_sda.letak_menu                                  OK
db_sda.peergroup                                   OK
db_sda.penelitian                                  OK
mysql.columns_priv                                 OK
mysql.db                                           OK
mysql.event                                        OK
mysql.func                                         OK
mysql.general_log                                  OK
mysql.help_category                                OK
mysql.help_keyword                                 OK
mysql.help_relation                                OK
mysql.help_topic                                   OK
mysql.host                                         OK
mysql.ndb_binlog_index                             OK
mysql.plugin                                       OK
mysql.proc                                         OK
mysql.procs_priv                                   OK
mysql.servers                                      OK
mysql.slow_log                                     OK
mysql.tables_priv                                  OK
mysql.time_zone                                    OK
mysql.time_zone_leap_second                        OK
mysql.time_zone_name                               OK
mysql.time_zone_transition                         OK
mysql.time_zone_transition_type                    OK
mysql.user                                         OK
mysql.user_info                                    OK
sim_sda.lokasi                                     OK
Running 'mysql_fix_privilege_tables'...
OK

Yah, ada ada saja gangguan dipagi hari..

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: