I have a server running on rackspace.com, it been running for about a year (collecting data for a project) and no problems. Now it seems mysql froze (could not connect either through ssh command line, remote app (sequel pro) or web (pages using the db just froze).
I got a bit eager to fix this quick and rebooted the virtual server, running ubuntu 10.10. It is a small virtual LAMP server (10gig storage - I'm only using 1, 256mb ram -has not been a problem). Now after the reboot, I cannot get mysql to start again.
service mysql status mysql stop/waiting
I believe this just means mysql is not running. How do I get this running again?
service mysql start start: Job failed to start
No. Just typing 'mysql' gives:
mysql ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
There is a .sock file in this folder,
ls -l gives:
srwxrwxrwx 1 mysql mysql 0 2012-12-01 17:20 mysqld.sock
I need the data in the database (so i'd like to avoid reinstalling), and I need it back up running again. All hint, tips and solutions are welcomed and appreciated.