修改免安装版的MySQL的默认配置

我用的是xampp 里面集成了mysql,但默认配置/mysql/bin/my.ini是my-small.ini

 

在mysql根目录下有my-huge.ini,my-innodb-heavy-4G.ini,my-large.ini,my-medium.ini,my-small.ini五种配置文件.现修改为my-large.ini的配置.注意要用#号屏蔽my.ini文件里关于InnoDB的配置文件,否则会出现以下错误.

 

111227 13:52:12 [Note] Plugin 'FEDERATED' is disabled.
111227 13:52:12 InnoDB: The InnoDB memory heap is disabled
111227 13:52:12 InnoDB: Mutexes and rw_locks use Windows interlocked functions
111227 13:52:12 InnoDB: Compressed tables use zlib 1.2.3
111227 13:52:12 InnoDB: Initializing buffer pool, size = 256.0M
111227 13:52:12 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file D:\xampp\mysql\data\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 67108864 bytes!
111227 13:52:12 [ERROR] Plugin 'InnoDB' init function returned error.
111227 13:52:12 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
111227 13:52:12 [ERROR] Unknown/unsupported storage engine: InnoDB
111227 13:52:12 [ERROR] Aborting

111227 13:52:12 [Note] D:\xampp\mysql\bin\mysqld.exe: Shutdown complete