Link to home
Start Free TrialLog in
Avatar of GMoney99
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
ASKER CERTIFIED SOLUTION
Avatar of johanntagle
johanntagle
Flag of Philippines image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial