topic Re: MySQL database dump in Archive

MySQL database dump

alanhale012 — Mon, 31 Jul 2017 17:25:49 GMT

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.

Re: MySQL database dump

flemingder — Wed, 02 Aug 2017 16:18:21 GMT

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