Reply
Highlighted
Member
Posts: 1
Registered: July
0
Accepted Solution

MySQL database dump

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.

Member
Posts: 2
Registered: August
0

Re: MySQL database dump

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