Home > Uncategorized > Log file .\ib_logfile0 is of different size 0

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)

 

 

Advertisements
Categories: Uncategorized
  1. Jim
    December 9, 2010 at 6:16 am

    Thank you for posting your fix. I played around with a few other suggestions and found your posting.

  2. Michael
    November 15, 2012 at 8:48 pm

    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.

  3. Shekhar
    May 10, 2016 at 2:02 pm

    Thanks it was really helpful

  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: