MySQL database dump

[alanhale012]

Hi all.

Does anyone use MySQL? When i try to create a MySQL database dump, get the following error:
Open table failed: Can't open file: '× × ×. MYI' (errno: 145).
Do you have any suggestions how to work around it? How to fix MySQL database?

Any hints would be appreciated. Thank you.

[flemingder · Accepted solution]

There are several ways to fix it; I'd sure like to find out why it keeps happening on one particular installation. Usually, running "REPAIR TABLE" from the mysql command line will work, but in one case I had to remove the .MYI file manually and rebuild the table from the backup. 

Also can recommend https://www.repairtoolbox.com/mysqlrepair.html