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.

MySQL Crash and Transfer Problem

Discussion in 'Database Discussions' started by johnmark33, Mar 20, 2013.

  1. johnmark33

    johnmark33 Registered

    Joined:
    Mar 20, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    So the situation is:

    1. Server A had a MySQL database running from a mounted drive (a custom, not default location)
    2. The mounted drive crashed, but fortunately the databases were saved elsewhere
    3. The accounts from Server A were transferred to a new Server B
    4. The databases were restored to the new Server B through the root account

    The problem is:
    The accounts on server B are not connecting to or showing the new databases when accessed via phpMyAdmin or any php script.

    Further notes:
    a. The databases DO show up on the CPanel of the accounts under "MySQL databases". CPanel shows the size correctly and all the tables correctly when trying to repair or check the tables directly through CPanel.
    b. The mysql database location on the new server B is the default MySQL directory which is different from the location that was on Server A. And I think this is the problem. Is there any place where an account can have a specific mysql directory set that is different from that specified by my.cnf?
     
  2. InterServed

    InterServed Well-Known Member

    Joined:
    Jul 10, 2007
    Messages:
    255
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    DataCenter Provider
    Hi,

    Not entirely sure but for me it sounds like you are missing the GRANTs that cpanel setup's when creating a mysql database/user. You may want to check into that.
     
  3. arunsv84

    arunsv84 Well-Known Member

    Joined:
    Oct 20, 2008
    Messages:
    373
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    127.0.0.1
    cPanel Access Level:
    Root Administrator
    Whats the location to MySQL database? Is it placed in the default location /var/lib/mysql ?
     
Loading...

Share This Page