以前机子是win server 2008 r2 ,mysql:5.5.25a-winx64 重装时只备份了data目录,以前也这样干过,重装后,直接拷贝目录就OK;
现在装了,win server 2012,mysql:5.5.29,拷过去,服务启动不了,提示1067,错误日志:
130105 15:52:32 [Note] Plugin 'FEDERATED' is disabled.
D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Incorrect file format 'plugin'
130105 15:52:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130105 15:52:32 InnoDB: The InnoDB memory heap is disabled
130105 15:52:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130105 15:52:32 InnoDB: Compressed tables use zlib 1.2.3
130105 15:52:32 InnoDB: Initializing buffer pool, size = 107.0M
130105 15:52:32 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 54525952 bytes
InnoDB: than specified in the .cnf file 0 56623104 bytes!
130105 15:52:32 [ERROR] Plugin 'InnoDB' init function returned error.
130105 15:52:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130105 15:52:32 [ERROR] Unknown/unsupported storage engine: INNODB
130105 15:52:32 [ERROR] Aborting130105 15:52:32 [Note] D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete如何处理?
data目录
现在装了,win server 2012,mysql:5.5.29,拷过去,服务启动不了,提示1067,错误日志:
130105 15:52:32 [Note] Plugin 'FEDERATED' is disabled.
D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Incorrect file format 'plugin'
130105 15:52:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
130105 15:52:32 InnoDB: The InnoDB memory heap is disabled
130105 15:52:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130105 15:52:32 InnoDB: Compressed tables use zlib 1.2.3
130105 15:52:32 InnoDB: Initializing buffer pool, size = 107.0M
130105 15:52:32 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 54525952 bytes
InnoDB: than specified in the .cnf file 0 56623104 bytes!
130105 15:52:32 [ERROR] Plugin 'InnoDB' init function returned error.
130105 15:52:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
130105 15:52:32 [ERROR] Unknown/unsupported storage engine: INNODB
130105 15:52:32 [ERROR] Aborting130105 15:52:32 [Note] D:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete如何处理?
data目录
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货