MySQL

Repair Tabel MySQL, Incorrect Key For Table

thesuhu2 Comments

MySQL Logo
Apabila anda mempunyai tabel MySQL yang rusak index-nya, biasanya akan menjumpai pesan error “Incorrect 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:

Gravatar
WordPress.com Logo

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

Google photo

You are commenting using your Google 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 )

Cancel

Connecting to %s