Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    151
    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,762
    Likes Received:
    116
    Trophy Points:
    343
    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:
    151
    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:
    166
    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

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice