Solved

MySQL Restore: Seeing error in logs.  IBData1

Posted on 2013-01-27
1
419 Views
Last Modified: 2013-04-04
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
0
Comment
Question by:GMoney99
1 Comment
 
LVL 24

Accepted Solution

by:
johanntagle earned 500 total points
ID: 38825230
I don't know if you need to be concerned but if you want peace of mind you can just recreate your ibdata1 by:

1. Do a mysqldump of all databases, procedures, triggers etc
2. Drop all databases except the mysql database
3. Stop mysql
4. Delete ibdata1 and ib_log files
5. Start mysql - this will recreate the ibdata1 and ib_log files
6. Restore your database from the dump

Hope this helps
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction In this article, I will by showing a nice little trick for MySQL similar to that of my previous EE Article for SQLite (http://www.sqlite.org/), A SQLite Tidbit: Quick Numbers Table Generation (http://www.experts-exchange.com/A_3570.htm…
I have been using r1soft Continuous Data Protection (http://www.r1soft.com/linux-cdp/) for many years now with the mySQL Addon and wanted to share a trick I have used several times. For those of us that don't have the luxury of using all transact…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now