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.