Web Hosting Talk : Web Hosting Main Forums : Hosting Security and Technology : mysql suddenly will not start

[aww]

under the shell on a cpanel server I tried to restart mysql - and it won't restart

/etc/init.d/mysql start
Starting MySQL................................... ERROR!

Where do I even begin to try to fix this?

TIA!

[aww]

from cpanel:

Attempting to restart mysql
Waiting for mysql to restart.... . . . . . . . . . . finished.

mysql status

mysql 7376 0.1 0.2 40552 4596 ? Sl 05:28 0:00 /usr/sbin/mysqld --basedir=/var/lib/mysql --datadir=/var/lib/mysql --user=mysql --pid-file=/var/lib/mysql/host.xxxxxxxxxxxxx.net.pid --skip-external-locking

r/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

[relichost]

Hi

Have you looked at your /etc/my.cnf file

maybe a long shot, but can you see if there is a line under [mysqld] something like skip-bdb ?

if there isnt put one in there and try a restart.

if not, is there something in the /var/log/mysqld.log

Thanks

[tanfwc]

aww, please check that your /var partition are not full.

[SV_Ngheo]

Originally Posted by aww

under the shell on a cpanel server I tried to restart mysql - and it won't restart

/etc/init.d/mysql start
Starting MySQL................................... ERROR!

Where do I even begin to try to fix this?

TIA!

try edit /etc/my.cnf , comment #base_dir and save it. Restart mysql.