Mysql considered as one of the reliable relational database management systems (RDBMS) which is capable to store the data safely in the form of tables. But sometimes you can face problems while executing queries on tables that indicate the table corruption which may occur due to virus attack, unexpected system shutdown, hard disk errors, improper execution of commands etc. In such situation, make use of an updated backup or go for mysql database recovery to restore the lost data.

To demonstrate the above example, let’s consider a situation where while accessing Mysql tables, you get the following error message on the screen:

“Record was already deleted (or record file crashed)"

Cause:

The foremost cause responsible for this error is Mysql database corruption due to which you can see decrease in the performance of queries while executing them.

Solution:

First of all, access the Mysql database using administrative privileges and after that make sure that the ‘record file crashed’ error is due to table corruption. For this, you need to execute the following command:

CHECK TABLE tablename

In case of MyISAM databases, use mysqlcheck or myisamchk command

If the above executed command reports yes, then run the following command:

REPAIR TABLE tablename

But even if the’ record was already deleted’ error remains, then delete the corrupted table but only if a valid or updated backup exists otherwise the best will be to go for mysql database recovery software which is especially meant to repair up all the mysql database corruption issues as well as restores all the database objects including tables, relations, primary key(s) etc. regardless of any corruption reasons.