CentOS running CPanel ran out of space, cannot start mysql or mysqld
I have a CentOS 6 server which is running CPanel. SugarCRM was installed
on a playground domain and nothing further was done with it. I began to
notice an unbelievable drop in available space, and overnight I dug around
and discovered that sugar had apparently created a cron job which was
piping a great deal of output into a hidden log file. I killed the cronjob
and removed the (17gb) worth of log files. I didn't realize that CPanel
was set up to install updates automatically, and during this process
CPanel attempted to install an update for which it didn't have enough
space. MySql server crashed as (according to the log file) it didn't have
enough space to write the pid or sock file. I have not been able to start
it yet. service mysqld restart yields the message: unrecognized service.
service mysql restart yields the following messages:
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]
There is no mysql pid file in /var/lib/mysql. I have checked permissions:
ls -la /var/lib/ | grep mysql
drwxr-xr-x 30 mysql mysql 4096 Aug 26 10:50 mysql/
there is nothing in the /var/lock/mysql file, and I don't see any lock files.
server.com.err file does have a message that the table ./mysql/user is
marked as crashed and should be repaired, though I've googled for hours
and have tried several methods of repairing this and have not yet been
successful.
mysqld_safe yields the following messages:
mysqld_safe Logging to '/var/lib/mysql/server.com.err'
mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
mysqld_safe mysqld from pid file /var/lib/mysql/server.com.pid ended
Also, I am completely missing the mysqld directory in /var/lib/mysql. When
I try:
/usr/sbin/mysqld --skip-grant &
I get the following:
[ERROR] Fatal error: Please read "Security" section of the manual to find
out how to run mysqld as root!
[ERROR] Aborting
[Note] /usr/sbin/mysqld: Shutdown complete
What am I to do? I've performed a complete (and duplicate) backup of all
of the databases found in /var/lib/mysql on a local hard drive and also to
an ftp location on a different host. Is the only thing left to do remove
and reinstall mysql server? I do have CPanel so I want to make sure what I
do is compatible with that.
No comments:
Post a Comment