GMoney99
asked on
MySQL Restore: Seeing error in logs. IBData1
Hi Experts,
We had a DB corrupted by a power outage. MySQL wouldn't start without a force recovery so I thought no big deal, I'll just restore from the latest backup. It happened overnight where no one would have likely been accessing the DB anyway.
So I restored from the latest backup and am checking the mysql log file and here is what I see over and over again:
130127 10:35:05 InnoDB: Error: page 21007 log sequence number 3 1509081591
InnoDB: is in the future! Current system log sequence number 0 827660907.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: for more information.
Everything is working fine on the site or appears to be. After searching around I see that this might be caused from a corrupt ibdata1 file. However ever, every post I see is people having issues where MySQL won't start. For me it is working fine so far.
Is this something I need to be concerned with? If so, how do I fix it? We do not have a backup of the ibdata1 file.
Thanks
G
We had a DB corrupted by a power outage. MySQL wouldn't start without a force recovery so I thought no big deal, I'll just restore from the latest backup. It happened overnight where no one would have likely been accessing the DB anyway.
So I restored from the latest backup and am checking the mysql log file and here is what I see over and over again:
130127 10:35:05 InnoDB: Error: page 21007 log sequence number 3 1509081591
InnoDB: is in the future! Current system log sequence number 0 827660907.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: for more information.
Everything is working fine on the site or appears to be. After searching around I see that this might be caused from a corrupt ibdata1 file. However ever, every post I see is people having issues where MySQL won't start. For me it is working fine so far.
Is this something I need to be concerned with? If so, how do I fix it? We do not have a backup of the ibdata1 file.
Thanks
G
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.