31-07-2017 06:25 PM
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.
02-08-2017 05:18 PM
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