oloony62 Posted June 21, 2016 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?
Greg H. Posted June 21, 2016 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.
phroper39 Posted July 3, 2016 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/
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