TEST STEP 0：创建测试环境：
----------------------
MYSQL 5140 at RHEL 5u4 X86_64
use test;
create table recover1 (id int auto_increment , c1 varchar(50), c2 varchar(100) ,primary key (id) ) engine=innodb;
insert into recover1(c1,c2) values ('aaaaaa','bbbbbb');
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;
insert into recover1(c1,c2) select c1,c2 from recover1 ;

SQL> select count(*) from recover1;
+----------+
| count(*) |
+----------+
| 4096 |
+----------+
1 row in set (0.03 sec)

SQL> show create table recover1 G
*************************** 1. row ***************************
Table: recover1
Create Table: CREATE TABLE `recover1` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`c1` varchar(50) DEFAULT NULL,
`c2` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16359 DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

SQL> truncate table recover1 ;
Query OK, 0 rows affected (0.03 sec)

##注意，在这里，你需要在文件被重新覆盖前，对数据所在表空间做一个镜像。否则你的数据也就无法恢复了。 你可以对MYSQL做一个FAST_SHUTDOWN。
如果你使用了：innodb_file_per_table，那么数据表空间文件就是： .ibd.
如果你使用了共享表空间，那么就是ibdata1....
cp /home/mysql/data/mysql/test/recover1.ibd /opt