The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

"The MySQL server is currently offline" after copying mysql data dir

Discussion in 'Database Discussions' started by FirestormX, Dec 24, 2010.

  1. FirestormX

    FirestormX Registered

    Joined:
    Dec 24, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    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
     
  2. FirestormX

    FirestormX Registered

    Joined:
    Dec 24, 2010
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Hi again,
    I'm sorry for double posting, but I recieved a couple suggestions from my hosting company, so I thought I should give a little update:

    Using "ps aux | grep mysql", I verified I am only running one instance of mysql, and I tried resetting my password to a single character, and WHM said it had reset, but I cannot check that it did reset.
    This has not fixed the problem.
     
  3. tblobaum

    tblobaum Registered

    Joined:
    Jan 12, 2011
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    I have this exact same problem after trying to create and associate database tables to users with the legacypostwww script

    My script is a simple bash script that creates a database and user when an account is first created. It works just fine. Whether or not it is related I am not sure, but suddenly I can no longer create databases/users with cpanel

    phpmyadmin still works exactly as expected for the root user. I have cleared out all of the databases and restarted mysql, as well as the server.

    Any help would really be appreciated!
     
  4. actived

    actived Well-Known Member

    Joined:
    Mar 30, 2012
    Messages:
    51
    Likes Received:
    0
    Trophy Points:
    6
    cPanel Access Level:
    Website Owner
    Exact same issue here.
    My Issue has arisen due to a "copy/transfer from another server" operation using the login option (not the SSH option)
    I reset the root password using mysqladmin from the command line - phpMyAdmin works, but creation is not allowed - cPanelX just refuses to go beyond "The MySQL® server is currently offline".
    The command line works fine - both mysql and mysqladmin.
    I can create users too.
    Only one mysqld_safe process is running.
    mysqladmin processlist shows up fine.
     
    #4 actived, May 29, 2012
    Last edited: May 29, 2012
Loading...

Share This Page