corrupt table

How recover corrupt table in MYSQL

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 [...]