首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > 其他数据库 >

mysql innodb 引擎初始化异常

2012-08-28 
mysql innodb 引擎初始化错误错误日志:?InnoDB: The InnoDB memory heap is disabledInnoDB: Mutexes and

mysql innodb 引擎初始化错误

错误日志:

?

InnoDB: The InnoDB memory heap is disabledInnoDB: Mutexes and rw_locks use GCC atomic builtinsInnoDB: Compressed tables use zlib 1.2.3110613 22:47:59  InnoDB: Initializing buffer pool, size = 1.0G110613 22:47:59  InnoDB: Completed initialization of buffer poolInnoDB: Error: data file /data1/mysqldata/mysql5.1.57/innodb_data/ibdata1 is of a different size(数据文件大小错误,重新配置innodb数据文件大小引起的初始化失败,)InnoDB: 640 pages (rounded down to MB)InnoDB: than specified in the .cnf file 128000 pages!InnoDB: Could not open or create data files.InnoDB: If you tried to add new data files, and it failed here,InnoDB: you should now edit innodb_data_file_path in my.cnf backInnoDB: to what it was, and remove the new ibdata files InnoDB createdInnoDB: in this failed attempt. InnoDB only wrote those files full ofInnoDB: zeros, but did not yet use them in any way. But be careful: do notInnoDB: remove old data files which contain your precious data!110613 22:47:59 [ERROR] Plugin 'InnoDB' init function returned error.110613 22:47:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

?删除innodb 数据文件 ibdata1

?

热点排行