Troubleshooting:MySQL will not start
From MythTV Official Wiki
Check Assumptions
Verify that MySQL is not running
gentoo# /etc/init.d/mysql start #ps -aef|grep mysql root 13817 13519 0 08:30 pts/1 00:00:00 grep mysql
Review Evidence
Investigate the logs
gentoo# less /var/log/mysql/mysqld.err
Identify Problem
What does the log say?
- InnoDB: Error: log file ./ib_logfile0 is of different size 0 8388608 bytes than specified in the .cnf file 0 5242880 bytes!
- [add other results here]
Verify Resolution
gentoo# /etc/init.d/mysql restart : # ps -aef|grep mysql mysql 15475 1 0 08:46 ? 00:00: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 :
Success!