Repair Tabel MySQL, Incorrect Key For Table

MySQL Logo
Apabila anda mempunyai tabel MySQL yang rusak index-nya, biasanya akan menjumpai pesan errorIncorrect key file for table ‘nama tabel’; try to repair it“. Untuk meperbaikinya jalankan query berikut:

REPAIR TABLE nama_tabel USE_FRM;

Tips:
Perhatikan pesan hasil query-nya, contoh pesan “Number of rows changed from 0 to 321”, artinya record yang berhasil di-recovery sebanyak 321 baris.

Semoga bermanfaat …

2 thoughts on “Repair Tabel MySQL, Incorrect Key For Table

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