dylanfrancis

Repairing tables with mysqlcheck or another variant to learn helpful topics about mysql databases https://social.msdn.microsoft.com/Forums/en-US/fb94219c-fbf8-455d-b912-5544be11f186/how-to-fix-my-sql-database?forum=sqldataaccess http://www.sqlservercentral.com/Forums/Topic1618894-2893-1.aspx But in case your corruption can't be overcome, then I would suggest you more powerful instrument for such cases https://mysql.recoverytoolbox.com/Recovery Toolbox for MySQL If you, by any chance, forgot to create backup, you should do more work as the following: Edit my.cnf (usually located in /etc/my.cnf) and add this line into [mysqld] section innodb_force_recovery=4 Restart mysql (e.g: /etc/init.d/mysqld restart) Your MySQL log should tell you which table is corrupt. You can dump the table using “SELECT … INTO OUTFILE …” from mysql console or using tool like mysqldump Example using MySQL query (you also need to dump the schema later) mysql> SELECT * FROM corrupted_table INTO OUTFILE ‘/path/to/file’ Example using mysqldump root# mysqldump –opt -u uname -p dbname corrupted_tablename > /path/to/out.sql Go back to my.cnf and comment the line you wrote from step #1 Go intoMySQL console and drop the corrupted table mysql> DROP TABLE corrupted_tablename; Import data dump, for sql dump you can use: root# mysql -u uname -p < /path/to/out.sql Go back into mysql console, check and optimize all tables Done