Question

1

mysql not starting

rated 0 times [ 1] [ 0] / answers: 1 / hits: 26594 / 1 Year ago, sat, may 20, 2023, 10:18:16

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 (10GB of storage - I'm only using 1.25GB of 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.

Answers

Only authorized users can answer the question. Please sign in first, or register a free account.

oreera

Add To Favorites

Follow

Total Points: 472

Total Questions: 121

Total Answers: 116

Location: Mayotte

Member since Thu, Dec 17, 2020

3 Years ago

oreera questions

1 What disadvantages are there to encrypting an entire hard drive or a home directory?

Wed, Aug 24, 22, 01:36, 2 Years ago

1 How to run cgexec without sudo as current user on Ubuntu 22.04 with cgroups v2, failing with "cgroup change of group failed"?

Sat, May 8, 21, 07:34, 3 Years ago

1 Netplan DNS nameserver setting not being applied

Thu, Jan 12, 23, 07:08, 1 Year ago

1 Ubuntu 20.04 when I tried to install RabbitMQ it showing this error

Wed, Dec 7, 22, 10:30, 1 Year ago

1 ImageMagick convert on a multiple files

Mon, Sep 5, 22, 00:56, 2 Years ago

View All

answered 1 Year ago tionpromoti · Accepted Answer

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 Ubuntu Forums 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.