Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

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.

share|improve this question
    
I've learned a new command line trick du -s -m * and while rackspace gives no indication I can find, it seems the disk indeed was full: ubuntuforums.org/showthread.php?t=804021 (the answer to this question on ubuntuforums was disk space). By upgrading to a bigger disk (and doubling my monthly bill), this seems to work fine. –  Eiriks Dec 2 '12 at 12:22

1 Answer 1

up vote 0 down vote accepted

The OP posted his solution as comment, copying it here as answer:

I've learned a new command line trick du -s -m * and while rackspace gives no indication I can find, it seems the disk indeed was full: http://ubuntuforums.org/showthread.php?t=804021 (the answer to this question on ubuntuforums was disk space). By upgrading to a bigger disk (and doubling my monthly bill), this seems to work fine.

Usually it is a good advice to look at the output of df and the sizes of /var/lib/mysql and /var/log/mysql.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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