"MySQL" InnoDB engine ibdata file corruption using IBD file to recover data

Reference: http://my.oschina.net/sansom/blog/179116

Reference: http://www.jb51.net/article/43282.htm

Attention! This method applies only to InnoDB instances of the innodb_file_per_table stand-alone table space.

This method can restore the Ibdata file was mistakenly deleted, maliciously modified, not from the library and backup data in the case of data recovery, by testing in Ibdata is modified, instance exception shutdown case, can not guarantee the database of all table data 100% recovery, the purpose is to recover as much as possible.

"InnoDB engine ibdata and IBD file Structure"

Recovery steps:

First, prepare a new instance

"MySQL" InnoDB engine ibdata file corruption using IBD file to recover data