Thread: MySQL crash and can't get it back up

hey !

run game server, uses mysql (quite few simultaneous connections) , last night experienced crash. apparently mysql server went down, , game went down.

thing is, have no idea how up, , can't seem find solution..

code:

/etc/init.d/mysql start

gives me :

code:

root@ks209052:/var/log/mysql# /etc/init.d/mysql start  rather invoking init scripts through /etc/init.d, use service(8)  utility, e.g. service mysql start    since script attempting invoke has been converted  upstart job, may use start(8) utility, e.g. start mysql  start: job failed start

, :

code:

mysql -u root -p

just gives me :

code:

error 2002 (hy000): can't connect local mysql server through socket '/var/run/mysqld/mysqld.sock' (111)

so looked , lot of people create mysqld.sock file, chmod 775 , chown mysql, did, no avail..

code:

root@ks209052:/# cd /var/run/mysqld  root@ks209052:/var/run/mysqld# touch mysqld.sock  root@ks209052:/var/run/mysqld# ls  mysqld.sock  root@ks209052:/var/run/mysqld# chmod 775 mysqld.sock  root@ks209052:/var/run/mysqld# ls -l  total 0  srwxrwxrwx 1 mysql mysql 0 2011-12-30 17:09 mysqld.sock  root@ks209052:/var/run/mysqld# chown mysql:mysql mysqld.sock  root@ks209052:/var/run/mysqld# ls -l  total 0  srwxrwxrwx 1 mysql mysql 0 2011-12-30 17:09 mysqld.sock  root@ks209052:/var/run/mysqld# mysql  error 2002 (hy000): can't connect local mysql server through socket '/var/run/mysqld/mysqld.sock' (111)

any clues ?

mark


quick edit: df -h shows me :

code:

filesystem            size  used avail use% mounted on  rootfs                9.7g  9.3g     0 100% /  /dev/root             9.7g  9.3g     0 100% /  /dev                   12g  164k   12g   1% /dev  none                   12g     0   12g   0% /dev/shm  none                   12g  112k   12g   1% /var/run  none                   12g     0   12g   0% /var/lock  none                   12g     0   12g   0% /lib/init/rw  /dev/sda2             1.8t  154g  1.6t   9% /home  tmpfs                 500m  427m   74m  86% /home/minecrafteurope/minecraft/astyxia/astyxia  tmpfs                 500m  351m  150m  71% /home/minecrafteurope/minecraft/astyxia/orebfuscator_cache

could because rootfs full ?

posted ephemeral

,...could because rootfs full ?

almost certainly.

Forum The Ubuntu Forum Community Ubuntu Official Flavours Support General Help [ubuntu] MySQL crash and can't get it back up

Ubuntu