Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

i was just checking somethings and noticed mysqld is not running in parallels power panel control panel...but my websites on the server were all working fine, which use mysql databases...so really strange

So i tried to restart mysqld but got errors and can't restart and now all my websites are all offline now saying error connecting to database.

logged in as root and tried

/etc/init.d/mysqld start

and got this error

ERROR! Manager of pid-file quit without updating file

What do i do next?

What do i do? Please help!

share|improve this question

migrated from stackoverflow.com Nov 20 '11 at 16:26

This question came from our site for professional and enthusiast programmers.

    
look at MySQL log, normally in /var/log/mysql.log or /var/log/mysql/mysql.log –  stivlo Nov 13 '11 at 7:05
    
and do what next? what do i do when i look at it? please explain –  grant tailor Nov 13 '11 at 7:07
    
at the end of that file, there might be an error. copy it here and you can get better help. –  stivlo Nov 13 '11 at 7:08
    
how do i see the file again because not working vi /var/log/mysql.log but don't see anything....also can i use nano editor" tried nano /var/log/mysql.log but got -bash: nano: command not found –  grant tailor Nov 13 '11 at 7:12
    
u still there ? –  grant tailor Nov 13 '11 at 7:16
show 1 more comment

1 Answer

up vote 4 down vote accepted

Is your hard drive out of space? Run:

df -h

Or try renaming /etc/my.cnf to /etc/my.cnf.old and it'll rebuild a new my.cnf.

It may also be in the /etc/mysql/my.cnf directory

UPDATE:

After chatting, we figured out that mysql was still running. Apparently, some people have reported this error message is caused when mysql doesn't shut down properly, but thinks it's shut down.

So we ran

ps aux | grep mysqld

To see running processes, then,

kill 23445 34255

To stop the processes...

Then /etc/init.d/mysqld start

to start the server back up.

share|improve this answer
    
no hard drive has 94GB free –  grant tailor Nov 13 '11 at 7:07
    
What about renaming the my.cnf file? –  Homer6 Nov 13 '11 at 7:09
    
how do i rename the my.cnf file and where do i see the my.cnf file? –  grant tailor Nov 13 '11 at 7:09
    
ls -lah /etc/my.cnf OR ls -lah /etc/mysql THEN mv /etc/my.cnf /etc/my.cnf.old –  Homer6 Nov 13 '11 at 7:14
    
i mean i am not trying do anything that will cause arm or i cannot reverse...so if i rename that file...will i be able to reverse that? and what will that do really? –  grant tailor Nov 13 '11 at 7:14
show 5 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.