Docstoc

How to Recover Corrupt 'ibdata1' File of InnoDB Storage Engine

Document Sample
How to Recover Corrupt 'ibdata1' File of InnoDB Storage Engine Powered By Docstoc
					?MySQL is a popular and widely used Relational Database Management System,
which uses different types of storage engines to store and manage data in the database.
Among all other storage engines of MySQL application, InnoDB is the most powerful
one. InnoDB storage engine uses 'ibdata1' file to store all your data. MySQL
application uses log files to refer the parts of 'ibdata1' file. In case the 'ibdata1' file
gets damaged, your entire MySQL database becomes inaccessible. In such situations,
you need to restore the database from current backup. In case the backup is not
updated or available, you need to Repair MySQL Database to extract inaccessible and
damaged data from it.

In a practical scenario, you may come across the below error message, when you
attempt to recover an InnoDB database table after an unexpected system shutdown:

"Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]"

Additionally, you may see the below entries in Application Event Log of MySQL:

"100317 21:53:25 mysqld started
100317 21:53:25 InnoDB: Error: page 1 log sequence number 0 69585642
InnoDB: is in the future! Current system log sequence number 0 15520.
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.
InnoDB: Database page corruption on disk or a failed
InnoDB: file read of page 2.
InnoDB: You may have to recover from a backup.
100317 21:53:25 InnoDB: Page dump in ASCII and hex (16384 bytes)"

Cause

This problem occurs due to corruption to the 'ibdata1' file. The corruption may occur
due to numerous reasons, such as virus infection, unexpected system shutdown,
operating system malfunction, and user errors.

Resolution

In order to Repair MySQL tables in such circumstances, you need to restore them
from the most recent backup. Backup is the redundant copy of your database, which
helps you to restore database in case of failure.

If backup is not available, mysql database repair software come for your help. The
applications are particularly designed to throughly scan entire database and Recover
MySQL database in all cases of corruption. The applications come equipped with
interactive and simple graphical user interface to enable easy recovery of damaged
MySQL database.

Database Recovery for MySQL software repairs and restores MySQL database for
InnoDB and MyISAM storage engines. It works well with MySQL 5.x and 4.x. The
software restores all damaged MySQL database objects, such as tables, reports, forms,
views, constraints, and more.

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:82
posted:5/3/2011
language:English
pages:2