oloony62 Posted June 21, 2016 Share Posted June 21, 2016 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? Link to comment Share on other sites More sharing options...
Greg H. Posted June 21, 2016 Share Posted June 21, 2016 Check https://dev.mysql.com/doc/refman/5.7/en/myisam-repair.htmlI'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 repairFirst, 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. Link to comment Share on other sites More sharing options...
phroper39 Posted July 3, 2016 Share Posted July 3, 2016 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 shutdownmysqlbackup --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/ Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now