重新安装Mysql数据库,配置: 程序文件和数据文件都在C:\Program files ibdata1在D:\MySQL Datafiles1.停Mysql服务 2.修改新装的ibdata1为ibdata1.bak 3.将待恢复的的ibdata1复制到D:\MySQL Datafiles 4.将opt和.frm文件C:\Program Files\MySQL\MySQL Server 5.0\data\test 5.启动mysql服务 6.停mysql服务报错信息: 120322 10:11:12 InnoDB: Error: page 7 log sequence number 0 62713 InnoDB: is in the future! Current system log sequence number 0 44556. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See http://dev.mysql.com/doc/mysql/en/backing-up.html for more information. ... ... 120322 10:11:13 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections. Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 120322 10:11:13 InnoDB: Error: page 239 log sequence number 0 5851343 InnoDB: is in the future! Current system log sequence number 0 44556. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See http://dev.mysql.com/doc/mysql/en/backing-up.html for more information. ... ... 120322 10:11:14 InnoDB: Error: page 247 log sequence number 0 5884129 InnoDB: is in the future! Current system log sequence number 0 44556. InnoDB: Your database may be corrupt or you may have copied the InnoDB InnoDB: tablespace but not the InnoDB log files. See http://dev.mysql.com/doc/mysql/en/backing-up.html for more information.
重新安装Mysql数据库,配置:
程序文件和数据文件都在C:\Program files
ibdata1在D:\MySQL Datafiles1.停Mysql服务
2.修改新装的ibdata1为ibdata1.bak
3.将待恢复的的ibdata1复制到D:\MySQL Datafiles
4.将opt和.frm文件C:\Program Files\MySQL\MySQL Server 5.0\data\test
5.启动mysql服务
6.停mysql服务报错信息:
120322 10:11:12 InnoDB: Error: page 7 log sequence number 0 62713
InnoDB: is in the future! Current system log sequence number 0 44556.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
http://dev.mysql.com/doc/mysql/en/backing-up.html for more information.
...
...
120322 10:11:13 [Note] C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt: ready for connections.
Version: '5.0.18-nt' socket: '' port: 3306 MySQL Community Edition (GPL)
120322 10:11:13 InnoDB: Error: page 239 log sequence number 0 5851343
InnoDB: is in the future! Current system log sequence number 0 44556.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
http://dev.mysql.com/doc/mysql/en/backing-up.html for more information.
...
...
120322 10:11:14 InnoDB: Error: page 247 log sequence number 0 5884129
InnoDB: is in the future! Current system log sequence number 0 44556.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
http://dev.mysql.com/doc/mysql/en/backing-up.html for more information.
http://www.percona.com/software/mysql-innodb-data-recovery-tools/