Tuesday, February 18, 2014

MySQL error mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

I recently upgraded MySQL 5.1 to 5.5.36 on CENTOS 6.5 64 bit

upgrade went well but MySQL won't start...

only one line logged under /var/log/mysqlerror.log

mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

hummm.... so PID error

tried many things... Google search for PID issues...but...

boy.... no matter what I tried...... I was not able to make mysql service start... then...


I ran command  mysql_safe ....

Voila... it gave me another log entry...

InnoDB: Error: log file ./ib_logfile0 is of different size 0 20356374 bytes
InnoDB: than specified in the .cnf file 0 5242880 bytes!




the error was because the size of innoDB logfile mention didnt match the size of logfile on the server...


so the solution was...

moving the current ib_logfiles to another location

cd ..

mkdir innodblog

mv /var/lib/mysql/ib_logfile* /var/lib/innodblog

service mysqld start

and finally it started...


Thanks

Recent Posts

IMA ADPCM CODEC 80000Khz 4Bit MONO Format for Phone Systems

Today I had a challenging task of setting up Auto Attendant on a Panasonic phone system. We required to record a Greeting message and upload...