Built For Designers & Developers

I would recommend you methods below to get back mysql data, but in case they won’t be effective, you may apply https://www.repairtoolbox.com/mysqlrepair.html Repair Toolbox for MySQL

Method 1.
Step 1. Log into mysql as administrator
mysql -uroot -p
Step 2. Select the database containing the corrupted table, i.e., ‘use {database name};’
mysql> use {database name};
Step 3. Show tables your corrupted table should be listed
mysql> show tables;
Step 4. Repair table
mysql> repair table {bad_table_name};

Method 2.
Step 1. Login to your MySQL server using Secure Shell (SSH).
Step 2. Repairing MyISAM mySQL Tables/Databases.
cd /var/lib/mysql/DBNAME
myisamchk -r -f tables.MYI
Please note that MyISAM is a default storage engine of MySQL, unless you change it. Mostly MyISAM is set as default engine to check and repair all the tables in the mysql database.