Re: Repair database
So I used the pieces advice the .err file gave me and got MySQL started back up. Now I am off to another recovery issue.
I'm on another computer that crashed (hard apparently) and throughout the .err file there are hundreds of these
InnoDB: Error: page 3224 log sequence number 271841351
InnoDB: is in the future! Current system log sequence number 271825023.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files.
I tried going in and putting innodb_force_recovery 1 into the .cnf file but that didn't seem to fix them issue, is there something I'm missing.
Additionally if I can't recover the database is there a way to pull some of the tables from the corrupted database and pasting them into a fresh one?
Thanks a ton for the help btw
Subject
Views
Written By
Posted
1684
May 18, 2016 07:49AM
Re: Repair database
870
May 19, 2016 08:40AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.