Jump to content
oloony62

mysql 5.7.11 database

Recommended Posts

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?

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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/

Share this post


Link to post
Share on other sites

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.