Posts: 1
Registered: ‎31-07-2017
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.

Posts: 2
Registered: ‎02-08-2017

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

/* /