Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

MySQL Restore: Seeing error in logs.  IBData1

Posted on 2013-01-27
1
Medium Priority
?
429 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
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 Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

597 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