Mysql crashed question
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
-
Hello :) It looks like InnoDB corruption based on the following snippet from the MySQL error log: [QUOTE]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: [url=http://dev.mysql.com/doc/refman/5.5/en/innodb-backup.html]MySQL :: MySQL 5.5 Reference Manual :: 14.3.17 InnoDB Backup and Recovery Thank you.0
Please sign in to leave a comment.
Comments
1 comment