problem in Mysql PID file

[3245]

hello
when i make restart mysql, i got following error:

[root@mail custombuild]# service mysqld restart
MySQL manager or server PID file could not be found! [FAILED]
Starting MySQL.Manager of pid-file quit without updating fi[FAILED]

i do locate mysql.pid (nothing)

[root@mail custombuild]# killall -9 mysql
mysql: no process killed


[root@mail custombuild]# ls -l /var/lib/mysql/

[root@mail custombuild]# ls -l /var/lib/mysql/
total 795540
drwx------ 2 mysql mysql 4096 Apr 23 03:29 da_roundcube
drwx------ 2 mysql mysql 20480 Jul 26 13:42 xxxxxxxxx_sub
-rw-rw---- 1 mysql mysql 10485760 Jul 26 03:28 ibdata1
-rw------- 1 mysql mysql 5242880 Jul 30 07:50 ib_logfile0
-rw------- 1 mysql mysql 5242880 Jul 25 03:09 ib_logfile1
-rw-rw---- 1 mysql root 792126336 Jul 30 07:50 mail.xxxxxxxx.com.err
drwx------ 2 mysql mysql 4096 May 24 11:11 mysql
-rw-rw---- 1 root root 2405 Jul 30 07:35 mysql-bin.000001
-rw-rw---- 1 root root 643759 Jul 30 07:35 mysql-bin.000002
-rw-rw---- 1 mysql mysql 38 Jul 30 07:35 mysql-bin.index
-rw-r--r-- 1 root root 6 May 24 11:11 mysql_upgrade_info
drwxr-xr-x 2 mysql mysql 4096 May 24 11:10 test

Help me for resolve it.

 

[chatwizrd]

read the .err file for the problem

 

[LawsHosting]

This was to do with innodb, had to put "skip-innodb" in /etc/my.cnf..... as i think innodb files were corrupt?

 

[Dauser2007]

solution very easy. go to /var/lib/mysql and delete mysql-bin.index and run #service mysqld start