Hello all,
I have, what I hope is, a fairly simple question.
A little background first: I had a dedicated server with a hosting company, and recently switched over to another server with the same company. They removed my hard drive and placed it in the new server temporarily so that I could extract the data (trying to copy my users/data over WHM failed for some reason).
One of the directories that I copied to the new machine was my mysql data directory (/var/lib/mysql). Now that I've moved it over, and chown'ed it to mysql.mysql (as in, "chown -R mysql.mysql /var/lib/mysql"), my databases seem to work fine. My PHP scripts are able to access the databases with no problems, just like they were before the server move.
However, when I try to "manage" the databases through cpanel, I get an error saying "The MySQL® server is currently offline", and none of my databases or users appear. (see this screenshot: http://img153.imageshack.us/img153/8761/cpanelv.jpg - it is not my own screenshot, but it is what I am seeing)
I cannot find much information about this on the internet, but a popular idea seems to be to reset the mysql root password via WHM, but the password reset fails.
This lead me to think that maybe the permissions/ownership were incorrect for the "mysql" database (/var/lib/mysql/mysql), but according to the following screenshot, it looks like my permissions match what this blogger has posted (note that article itself can be ignored):
Map MySQL Databases Outside /var/lib/mysql
I'm also able to access and modify my databases through phpmyadmin.
Have you seen this problem before, and/or would you be able to suggest a direction I could look in?
I don't mind investigating and digging around, but I've spent several hours trying to figure this out myself, and I'm hoping someone here might have an idea as to what the problem might be.
Thank you for your time



LinkBack URL
About LinkBacks
Reply With Quote




