Jump to content

Recommended Posts

Posted

I use MySQL database for couple of weeks. Today I have worked in my database I saved it. Then I tried to open the database and saw - Index file is crashed. I checked backup copy it disappeared. Can someone suggest what can I do?

Posted

Check https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.html

I'm not that familiar with mySQL, but this walks through repairing broken files within the database.

It does include instructions for repairing the index file,

Stage 2: Easy safe repair
First, try myisamchk -r -q tbl_name (-r -q means quick recovery mode[/size]”[/size]). This attempts to repair the index file without touching the data file.


But I would read the entire article and follow the steps as listed.

  • 2 weeks later...
Posted

Try to open database in another version of MySQL, in case it won't help, then you may use next command:

mysqladmin --defaults-file=/usr/local/mysql/my.cnf --user=root --password shutdown
mysqlbackup --defaults-file=/usr/local/mysql/my.cnf \
--backup-dir=/export/backups/full \
copy-back

When nothing helps when apply to Recovery Toolbox for MySQL, this solution has demo, you may try it on https://mysql.recoverytoolbox.com/

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.