How To Repair MySQL Database
It is possible to check and repair a MySQL database using tools that are shipped with the DB.
Depending on the situation this may or may not work. Your milage may vary. Just be aware that things can go wrong and this is not guaranteed to work.
You can use the following command to check and repair a MySQL database:
mysqlcheck -u username -p --repair my_db_1
The “–repair” option specifies that the command should attempt to repair the database.