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
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
