Steps to Recover a corrupt table in mysql

1)      Go to  /var/lib/mysql/DB_Name  (Assuming DB is stored in given path)

2)      Run below command to scan whole DB to check for errors.

myisamchk /var/lib/mysql/DB_NAME/*.MYI >> /tmp/myisamchk_log.txt (Report will be exported in .txt format)

Use can see babel_user is corrupted

3)      Now run myisamchk –r babel_user.MYI command recover the said table.

After completion you can see above result.

Post By Dinesh (18 Posts)