Rumah > pangkalan data > tutorial mysql > InnoDB: Error: log file ./ib_logfile0 is of different size 0_MySQL

InnoDB: Error: log file ./ib_logfile0 is of different size 0_MySQL

WBOY
Lepaskan: 2016-06-01 13:08:29
asal
1039 orang telah melayarinya

启动WAMP Server的时候报如下的错误:

140618 23:12:32 [Note] Plugin 'FEDERATED' is disabled.140618 23:12:32 InnoDB: The InnoDB memory heap is disabled140618 23:12:32 InnoDB: Mutexes and rw_locks use Windows interlocked functions140618 23:12:32 InnoDB: Compressed tables use zlib 1.2.3140618 23:12:32 InnoDB: Initializing buffer pool, size = 128.0M140618 23:12:32 InnoDB: Completed initialization of buffer poolInnoDB: Error: log file ./ib_logfile0 is of different size 0 10485760 bytesInnoDB: than specified in the .cnf file 0 5242880 bytes!140618 23:12:32 [ERROR] Plugin 'InnoDB' init function returned error.140618 23:12:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.140618 23:12:32 [ERROR] Unknown/unsupported storage engine: InnoDB140618 23:12:32 [ERROR] Aborting
Salin selepas log masuk
请注意这几行:

InnoDB: Error: log file ./ib_logfile0 is of different size 0 10485760 bytesInnoDB: than specified in the .cnf file 0 5242880 bytes!
Salin selepas log masuk
你可以计算一下10485760的大小,10485760/1024/1024=10,修改my.ini,

innodb_log_file_size = 10M
Salin selepas log masuk
要看mysql的日志,请进行如下操作:



sumber:php.cn
Kenyataan Laman Web ini
Kandungan artikel ini disumbangkan secara sukarela oleh netizen, dan hak cipta adalah milik pengarang asal. Laman web ini tidak memikul tanggungjawab undang-undang yang sepadan. Jika anda menemui sebarang kandungan yang disyaki plagiarisme atau pelanggaran, sila hubungi admin@php.cn
Tutorial Popular
Lagi>
Muat turun terkini
Lagi>
kesan web
Kod sumber laman web
Bahan laman web
Templat hujung hadapan