mahdy_sharifi

Well-Known Member
Feb 26, 2012
220
1
68
cPanel Access Level
Root Administrator
Hello :

Our database server suddenly crashed when I restart it.
after too long trying to find problem and recover database and innodb , no any success .
So I decided to use database backup , We had database file backup , means database ibd , MIY , ... ibdata .
Then I create a new dir and move bakup there and set this directory as a new database directory .

but again when start database , database crashed again.
following occur log : Attached

I want know based following logs , may our server have any problem that cause database crashing ?

Thank you
 

Attachments

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,880
2,267
463
Hello :)

It looks like InnoDB corruption based on the following snippet from the MySQL error log:

140413 3:23:47 InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 InnoDB: Probable data corruption on page 6
InnoDB: Original record (compact record)
InnoDB: on that page.
InnoDB: Cannot find the dir slot for record (compact record)
InnoDB: on that page!
The following document is a good place to start when handling InnoDB corruption:

MySQL :: MySQL 5.5 Reference Manual :: 14.3.17 InnoDB Backup and Recovery

Thank you.