Suddenly No Mysql

[damanmokha]

Hi.

I am newbie, please help. Yesterday it was working fine. now mysql is stopped suddenly? i checked typing mysql to console. its shows me this eroor

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

When i tried to restart mysqld it shows me

-bash: /etc/init.d/mysqld: No such file or directory

I am worried what to do. dont have backups. still downloading msyql db files from ftp. But why this happend and what is the best solution? my all 22 domains are down and unable to connect db. Please help.

[andreapuglisi95]

Hi.

I am newbie, please help. Yesterday it was working fine. now mysql is stopped suddenly? i checked typing mysql to console. its shows me this eroor

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

When i tried to restart mysqld it shows me

-bash: /etc/init.d/mysqld: No such file or directory

I am worried what to do. dont have backups. still downloading msyql db files from ftp. But why this happend and what is the best  solution? my all 22 domains are down and unable to connect db. Please help.

Hi! Check if your /var directory is full via ssh . I had the some problem 2 days ago.
cd  / and after type df -h

[damanmokha]

Hi! Check if your /var directory is full via ssh . I had the some problem 2 days ago.
cd  / and after type df -h

This is the result. after this : df-h

Filesystem      Size  Used Avail Use% Mounted on
/dev/simfs      500G   30G  471G   6% /
devtmpfs        1.0G     0  1.0G   0% /dev
tmpfs           1.0G     0  1.0G   0% /dev/shm
tmpfs           1.0G   98M  927M  10% /run
tmpfs           1.0G     0  1.0G   0% /sys/fs/cgroup

[andreapuglisi95]

Hi! Check if your /var directory is full via ssh . I had the some problem 2 days ago.
cd  / and after type df -h

This is the result. after this : df-h

Filesystem      Size  Used Avail Use% Mounted on
/dev/simfs      500G   30G  471G   6% /
devtmpfs        1.0G     0  1.0G   0% /dev
tmpfs           1.0G     0  1.0G   0% /dev/shm
tmpfs           1.0G   98M  927M  10% /run
tmpfs           1.0G     0  1.0G   0% /sys/fs/cgroup

Uhmm it seems to be ok. Have you tried to restart mysqld with this code, service mysqld restart ? And try a reboot of the server if you can.

[damanmokha]

yes i tried already before posting this thread it shows

-bash: /etc/init.d/mysqld: No such file or directory

as mentioned in the first. i tried to install also. it is letting me do. but i didn't proceed the install of mysql guessing it may conflict with something.

[andreapuglisi95]

You can try also sudo chmod -R 755 /var/lib/mysql/ and sudo service mysqld restart

[damanmokha]

You can try also sudo chmod -R 755 /var/lib/mysql/ and  sudo  service mysqld restart

This is the error after 2nd command

Failed to issue method call: Unit mysqld.service failed to load: No such file or directory.

and i looked up here /etc/init.d/ via ssh there is no file named mysqld it has only 4 other files.

[andreapuglisi95]

Uhmmmmm, an additional method for getting it back up again is try to move mysql.sock:

mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak

service mysqld start
Restarting the service creates a new entry called mysql.sock

[damanmokha]

Uhmmmmm, an additional method for getting it back up again is try to move mysql.sock:

mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak

service mysqld start
Restarting the service creates a new entry called mysql.sock

Same thing after those commands. I dont have mysql.sock.bak in that dir. and  mysql.sock is 0 byte i downloaded all db's form same folder and that mysql.sock file is always failed downloading.

[andreapuglisi95]

Mmm.. Do you upgraded your mysql via unofficial method ? Or it's the sentora's original?