我试图通过更改my.ini文件中的datadir参数来更改MySQL的数据文件夹路径 . 但是当我再次重启MySQL服务时,我收到以下错误:
错误1067:进程意外终止 .
我检查了.err文件,出现以下错误:(它们都是关于InnoDB的)
120319 3:59:59 [Note] Plugin 'FEDERATED' is disabled.
120319 3:59:59 InnoDB: The InnoDB memory heap is disabled
120319 3:59:59 InnoDB: Mutexes and rw_locks use Windows interlocked functions
120319 3:59:59 InnoDB: Compressed tables use zlib 1.2.3
120319 3:59:59 InnoDB: Initializing buffer pool, size = 75.0M
120319 3:59:59 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file .\ib_logfile0 is of different size 0 99614720 bytes
InnoDB: than specified in the .cnf file 0 39845888 bytes!
120319 3:59:59 [ERROR] Plugin 'InnoDB' init function returned error.
120319 3:59:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
120319 3:59:59 [ERROR] Unknown/unsupported storage engine: INNODB
120319 3:59:59 [ERROR] Aborting
1 回答
您必须在my.cnf或my.ini中指定正确的大小:innodb_log_file_size = 95M . 目前我猜它是38M .
还要从您的数据文件夹中检查您拥有多少ib_logfiles . 如果您有2个以上,请同时指定:innodb_log_files_in_group = 2 .