mysql innodb ibdata ib_logfile_原数据库使用innodb引擎，已备份[dbname]文件夹、ibdata1、ib_logfile0、ib_logfile1，但是没有my....

新建同样数据库后，把备份的文件覆盖上，mysql启动报错1067，log文件内容如下：13070511:57:33[Note]Plugin'FEDERATED'isdisabled.13070511:57:33InnoDB:TheInnoDBmemoryheapisdisabl...

新建同样数据库后，把备份的文件覆盖上，mysql启动报错1067，log文件内容如下：

130705 11:57:33 [Note] Plugin 'FEDERATED' is disabled.

130705 11:57:33 InnoDB: The InnoDB memory heap is disabled

130705 11:57:33 InnoDB: Mutexes and rw_locks use Windows interlocked functions

130705 11:57:33 InnoDB: Compressed tables use zlib 1.2.3

130705 11:57:33 InnoDB: Initializing buffer pool, size = 142.0M

130705 11:57:33 InnoDB: Completed initialization of buffer pool

InnoDB: Error: checksum mismatch in data file .\ibdata1

130705 11:57:33 InnoDB: Could not open or create data files.

130705 11:57:33 InnoDB: If you tried to add new data files, and it failed here,

130705 11:57:33 InnoDB: you should now edit innodb_data_file_path in my.cnf back

130705 11:57:33 InnoDB: to what it was, and remove the new ibdata files InnoDB created

130705 11:57:33 InnoDB: in this failed attempt. InnoDB only wrote those files full of

130705 11:57:33 InnoDB: zeros, but did not yet use them in any way. But be careful: do not

130705 11:57:33 InnoDB: remove old data files which contain your precious data!

130705 11:57:33 [ERROR] Plugin 'InnoDB' init function returned error.

130705 11:57:33 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

130705 11:57:33 [ERROR] Unknown/unsupported storage engine: INNODB

130705 11:57:33 [ERROR] Aborting

请教如何修改my.ini，或如何能正常启动mysql，只要能导出[dbname].sql就行

展开