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!
  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:
    151
    Location:
    San Francisco
    How do I restore a MySQL database which was backed up via cPanel's full site backup feature?
     
    #1 StealthDesign, Nov 5, 2003
  2. sparek-3

    sparek-3 Well-Known Member

    Joined:
    Aug 10, 2002
    Messages:
    1,599
    Likes Received:
    60
    Trophy Points:
    328
    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.
     
    #2 sparek-3, Nov 7, 2003
  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
     
    #3 StealthDesign, Nov 7, 2003
  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
     
    #4 simplybe, Nov 8, 2003
(You must log in or sign up to post here.)
Loading...
Similar Threads - Restore MySQL data
  1. sodapopinski

    Restore mysql database to server with maria DB?

    sodapopinski, Oct 19, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    367
    cPWilliamL
    Oct 19, 2017
  2. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    669
    cPanelMichael
    Oct 11, 2016
  3. postcd

    Restore backups/import without MySQL resetting mysql passwords?

    postcd, Aug 30, 2017, in forum: Data Protection
    Replies:
    5
    Views:
    452
    cPanelMichael
    Mar 22, 2018
  4. postcd

    How to restore all files backups and a mysql separately?

    postcd, Aug 29, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    393
    cPanelMichael
    Aug 31, 2017
  5. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    576
    Naila
    Jun 22, 2017

Share This Page