Repair MySQL Tables
How to Repair MySQL Tables ?
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’
