MySQL not working after server reboot?

[myilmaz]

Hi,

Tomorrow my website didn't work, on advice from the host company i did a reboot and migrated to another node. Now the server is working, but there seems to be a problem with mysql. In directadmin in MYSQL Management i see this message:

Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

The websites are running on Magento and in that error log file there is a message: No such file or directory lib/Zend/Db/Adapter/Pdo/Mysql.php

Maybe interesting.. in Directadmin var/log/directadmin/errortaskq.log i see this messages constantly:

2014:05:28-08:03:11: service named didn't start, re-starting it
2014:05:28-08:04:01: service mysqld wasn't running, starting it
2014:05:28-08:04:06: service named wasn't running, starting it
2014:05:28-08:04:11: service named didn't start, re-starting it
2014:05:28-08:05:01: service mysqld wasn't running, starting it
2014:05:28-08:05:06: service named wasn't running, starting it
2014:05:28-08:05:11: service named didn't start, re-starting it
2014:05:28-08:06:01: service mysqld wasn't running, starting it
2014:05:28-08:06:06: service named wasn't running, starting it
2014:05:28-08:06:11: service named didn't start, re-starting it


Is there a way to recover this whitout losing data?

Thanks

 

[thunn]

You will see more detail when check mysql log file. Mark the last line, save the log file and then run $service mysqld restart
After that, check log file again, you will see problem, start from the line you marked.

Also, don't forget to make a copy of folder to a safe area, to recover data if needed: /var/lib/mysql/

 

[myilmaz]

Problem solved, Thanks thunn! I have disabled this two rules: #table_cache = 512
#query_cache_limit: 2MB and after that it works fine.