Today I faced issue again with MySQL running of NFS .I was trying to shutwon mysql
using /etc/rc.d/init.d/mysql stop
MySQL shutdown was successful .
after making changes in my.cnf file I tried to start MySQL using
/usr/bin/mysqld_safe –defaults-file=/etc/my.cnf &
I got error
mysqld_safe A mysqld process already exists
I checked that no other instance is running using
ps aux| grep MySQL
I got no MySQL process running, as I have faced so many errors because of the NFS
locking the files mentioned in my previous posts
http://onaxer.com/blog/blog/2011/02/26/error-1033-hy000-incorrect-information-in-file/
http://onaxer.com/blog/blog/2011/02/23/innodb-unable-to-lock-ib_logfile0-error-11/
http://onaxer.com/blog/blog/2010/06/01/innodb-unable-to-lock-ibdata1-error-37/
I tried the same solution again
1) /etc/init.d/portmap restart
2) /etc/init.d/nfslock restart
And it worked. I was able to start MySQL after that successfully.