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.

How Do I Restore MySQL data from a Full Site Backup?

Discussion in 'General Discussion' started by StealthDesign, Nov 5, 2003.

  1. StealthDesign

    StealthDesign Member

    Joined:
    Oct 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    San Francisco
    How do I restore a MySQL database which was backed up via cPanel's full site backup feature?
     
  2. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,384
    Likes Received:
    23
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    I think there is a mysql directory in the tar.gz file. When you extract the tar.gz file, move the contents of that mysql directory into /var/lib/mysql . I believe this is the correct procedure. Its been a while since I manually restored a MySQL database, and I'm just going from memory.
     
  3. StealthDesign

    StealthDesign Member

    Joined:
    Oct 10, 2003
    Messages:
    19
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    San Francisco

    Thank you, I will give that a try. Once I figure out how to get SSH working that is. :D
     
  4. simplybe

    simplybe Well-Known Member

    Joined:
    Nov 29, 2002
    Messages:
    153
    Likes Received:
    0
    Trophy Points:
    16
    you will also need to chown the files and chmod them via ssh once you have uploaded them.

    chown -R mysql.mysql /var/lib/mysql/user_dbname
     
Loading...

Share This Page