Repair MySQL Tables

Home > Bookmarks, Hosting, Linux, MySQL > Repair MySQL Tables

November 17th, 2007 Leave a comment Go to comments

1. Login on server
2. Type next linux command in your mysql folder with MYI files :

myisamchk -r –sort-index –analyze *.MYI

folder ex: /var/lib/mysql/yourdatabase/

*NOTE:
- DO NOT TYPE ANYTHING BEFORE BACKUP DATABASE!
- If you request warnig about table damage use in in phpMyAdmin for repair this:

REPAIR TABLE `tbl_name’