I upgraded Mysql 5.0 to Mysql 5.5.8 and start mysql. It was working fine but when i enable innodb and try to start Mysql i was not able to start it. pass4real
I checked the Mysql error logs, saw below errors
[root@manoj mysql]# tail /var/log/mysqld.log
InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes 642-902 dumps
InnoDB: than specified in the .cnf file 0 1073741824 bytes!
110603 7:34:15 [ERROR] Plugin ‘InnoDB’ init function returned error.
110603 7:34:15 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
110603 7:34:15 [ERROR] Unknown/unsupported storage engine: InnoDB
110603 7:34:15 [ERROR] Aborting
10603 7:34:15 [Note] /usr/sbin/mysqld: Shutdown complete
I moved the ib_logfile0 and ib_logfile01 to bak and start Mysql again. Now this time, it is working fine
[root@Manoj mysql]# mv ib_logfile0 ib_logfile0-bak
[root@Manoj mysql]# mv ib_logfile1 ib_logfile1-bak