Sign up ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Yesterday, we updated cPanel to version 11.32.2 (build 8). After the update, the MySQL server went down and it doesn't restart. MySQL is down now. MySQL version is 5.5.

I tried to reinstall MySQL, but it didn't work. The server is based on CentOS.

What can we do?

share|improve this question

closed as too localized by Chris S Mar 22 '12 at 12:43

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

Check the system logs and the database's logs for more detailed errors? – Bart Silverstrim Mar 22 '12 at 12:03

1 Answer 1

up vote 2 down vote accepted

Start by checking the MySQL error log, whilst attempting to start MySQL

tail -n100 -F /var/lib/mysql/*.err

Then in another session,

service mysql start

That will give you a rough indication of why it is failing to start. It could be anything at this stage,

  1. Full /var partition
  2. /tmp partition non-writable (or too small)
  3. ulimit too restrictive for open_files or memory
  4. Crashed/faulty/broken tables

My advice would be to consult a professional, this is a Q&A site and your question is far too localised to have value/relevance to other users (without more explicit detail).

share|improve this answer

Not the answer you're looking for? Browse other questions tagged or ask your own question.