Here's what I get when I start the mysql init script: minuet mysql # /etc/init.d/mysql start * Caching service dependencies ... [ok] * ... * Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" * it will be removed now and re-created by the MySQL server * BUT please make your checks. * Starting mysql (/etc/mysql/my.cnf) [ok] mysqld isn't running... minuet mysql # ps ax |grep mysql 29736 pts/1 S+ 0:00 grep mysql look what happens when I run mysqld: minuet mysql # mysqld InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 060511 16:57:25 [ERROR] Can't init databases 060511 16:57:25 [ERROR] Aborting 060511 16:57:25 [Note] mysqld: Shutdown complete If I delete the ib_logfile0 and ib_logfile1, mysql will start correctly: minuet mysql # /etc/init.d/mysql start * ... * Strange, the socket file already exist in "/var/run/mysqld/mysqld.sock" * it will be removed now and re-created by the MySQL server * BUT please make your checks. * Starting mysql (/etc/mysql/my.cnf) [ ok ] minuet mysql # ps ax |grep mysql 29919 ? Ssl 0:00 /usr/sbin/mysqld --defaults-file=/etc/mysql/my.cnf --basedir=/usr --datadir=/var/lib/mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock 29930 pts/1 R+ 0:00 grep mysql So the bug is: Expected result: -an error when I run /etc/init.d/mysql Actual result: -I see [ok] when I run /etc/init.d/mysql even though it didn't start -Even better: show the error output from mysqld: InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes InnoDB: than specified in the .cnf file 0 5242880 bytes! 060511 16:57:25 [ERROR] Can't init databases 060511 16:57:25 [ERROR] Aborting
Well, the error is clear, the InnoDB logfile is different than what is set in my.cnf, we can't really do much about that ourselves... Deleting the file or changing the my.cnf settings should fix this. Best regards, CHTEKK.
