Log file .\ib_logfile0 is of different size 0
When removing a site from Plesk, I got an error saying it could not connect to MySQL. I tried to start the service, which wouldn’t start, and got this in the event log:
Failed to connect to database: Can’t connect to MySQL server on ‘localhost’ (10061)
at Turn off domain xxx.com (state=1)(domainmng::turnDomain line 104)
Execute file name: C:\Program Files\SWsoft\Plesk\admin\bin\domainmng.exe
Trying to start MySQL from the command prompt gave this error:
C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin>mysqld-nt.exe –console
InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
InnoDB: than specified in the .cnf file 0 209715200 bytes!
101111 15:30:10 [ERROR] Can’t init databases
101111 15:30:10 [ERROR] Aborting
101111 15:30:10 [Note] mysqld-nt.exe: Shutdown complete
So, after looking in the –help options, and reading online I found this fix:
C:\Program Files\SWsoft\Plesk\Databases\MySQL\bin>mysqld-nt.exe –console –innodb_log_file_size=10M
101111 15:30:29 InnoDB: Started; log sequence number 0 135464
mysqld-nt.exe: ready for connections.
Version: ‘4.1.18-nt-log’ socket: ” port: 3306 MySQL Community Edition (GPL)
Thank you for posting your fix. I played around with a few other suggestions and found your posting.
LikeLike
I ran into this a problem like this after reinstalling mysql. Deleting the log files worked but on my system it was hard to find where it was pulling the files from. I ended up removing the files under “ProgramData” folder on windows 7. Then my test server started working again. Hope this helps someone.
LikeLike
Thanks it was really helpful
LikeLike