Tag Archives: mysql not restarting after upgrade

MySQL server not starting – Part 3

A common issue when MySQL versions are upgraded is the presence of depreciated commands in /etc/my.cnf that would prevent MySQL from restarting.  Other than the presence of depreciated ones, incomplete commands too can cause the issues.

When MySQL is upgraded to 5.5 from 5.1 or so, you might see that the service doesnt get restarted. Looking at the configuration file at /etc/my.cnf do you find something like this ?

slow_query_log_file

Here the path is not referenced, which is the issue confronted. Usually if slow_query_log is enabled in the configuration, then the path to log file should be mentioned, like :

slow_query_log_file=/path-to-file

Either comment off the incorrect line or if you are depending on slow_query_log mention the path to the log file as shown above. Once this is given, your service would restart fine.