Skip to content

Solution – Manager of pid-file quit without updating file

If you are getting this error when you try to start mysql server, mysql is having a problem with one of the variables that you have in its configuration file my.cnf.

Manager of pid-file quit without updating file

First verify that this is true. Rename my.cnf to my.old.cnf and try starting the server again. If you do not know where my.cnf is, you can do “locate my.cnf”.

If mysql server starts fine when you rename my.cnf, it confirms that it is having a problem with your my.cnf file. Rename the file back to its original name and try starting the server. Once you get the “Manager of pid-file quit without updating file” error message, head to the mysql error log. This error log may be under your system’s log directory (/var/log/mysql) or under the mysql data folder (usually /usr/local/mysql/data). Tail the file to see the problem.

Solution for mysql “InnoDB: No valid checkpoint found.” error

In my case the error log listed the following items:

InnoDB: No valid checkpoint found.
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
110621 5:34:31 [ERROR] Plugin ‘InnoDB’ init function returned error.
110621 5:34:31 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.

After some Googling, I found out that this problem was due to the InnoDB logs. I deleted ib_logfile0 and ib_logfile1 and I was able to start mysql server without any problems. These files are usually under the mysql data directory.

Categories: Windows tips.

Comment Feed

2 Responses

  1. Thank you man. We’ve been searching for this solution for hours.

    Bahadır BirsözJanuary 23, 2012 @ 8:33 pmReply
  2. Thansk you very much!
    It helps me!

    AlexanderJune 1, 2012 @ 10:28 amReply

Some HTML is OK

or, reply to this post via trackback.