Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MySQL Restore: Seeing error in logs.  IBData1

Posted on 2013-01-27
1
Medium Priority
?
432 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 1500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

580 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