0

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!

6
  • look at MySQL log, normally in /var/log/mysql.log or /var/log/mysql/mysql.log
    – stivlo
    Nov 13, 2011 at 7:05
  • and do what next? what do i do when i look at it? please explain Nov 13, 2011 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, 2011 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 Nov 13, 2011 at 7:12
  • u still there ? Nov 13, 2011 at 7:16

1 Answer 1

5

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.

10
  • no hard drive has 94GB free Nov 13, 2011 at 7:07
  • What about renaming the my.cnf file?
    – Homer6
    Nov 13, 2011 at 7:09
  • how do i rename the my.cnf file and where do i see the my.cnf file? Nov 13, 2011 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, 2011 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? Nov 13, 2011 at 7:14

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .