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.
Solved! Go to 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