If this error occurs. Its an information, that one or more tables are corrupted in your database that needs to be repaired.
Here, In the First step, We need to find the corrupted tables to repair.
Execute a command to find the corrupted tables.
Myisamchk -s / var / lib / mysql/*/*.MYI
MyISAM-table ‘ /var / lib / mysql / dbname / table name. MYI ‘ should be rebuilt and marked as crashed.
Once, We found all the corrupted tables, Now we move to the next step to repair these tables by using another command line.
# myisamchk -r / var / lib / mysql / dbname / table name. MYI
Using the above command, you can fix all corrupted tables in your precious database.
Still not fixed, Then I strongly suggest you to move for a DIY MySQL repair tool because I believe your data is more valuable to your time or a few dollars. With help of any DIY tool, you can repair your data with ease & data security.
I found a tool for you that you can try Stellar Repair for MySQL It's recommended by many DBAs with 4.6 User ratings out of 5.
Thanks
Here, In the First step, We need to find the corrupted tables to repair.
Execute a command to find the corrupted tables.
Myisamchk -s / var / lib / mysql/*/*.MYI
MyISAM-table ‘ /var / lib / mysql / dbname / table name. MYI ‘ should be rebuilt and marked as crashed.
Once, We found all the corrupted tables, Now we move to the next step to repair these tables by using another command line.
# myisamchk -r / var / lib / mysql / dbname / table name. MYI
Using the above command, you can fix all corrupted tables in your precious database.
Still not fixed, Then I strongly suggest you to move for a DIY MySQL repair tool because I believe your data is more valuable to your time or a few dollars. With help of any DIY tool, you can repair your data with ease & data security.
I found a tool for you that you can try Stellar Repair for MySQL It's recommended by many DBAs with 4.6 User ratings out of 5.
Thanks