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,436
    Likes Received:
    31
    Trophy Points:
    178
    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. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    398
    cPanelMichael
    Oct 11, 2016
  2. Naila

    Mysql Always Restarting During Full Backup Restore

    Naila, Jun 20, 2017, in forum: Database Discussions
    Replies:
    4
    Views:
    185
    Naila
    Jun 22, 2017
  3. djbaxter

    SOLVED The MySQL restore process died from the “SEGV” signal.

    djbaxter, Mar 11, 2017, in forum: Data Protection
    Replies:
    8
    Views:
    1,303
    cPanelMichael
    Apr 4, 2017
  4. gnusys

    cPanel account restore does not work for remote mysql profile

    gnusys, Feb 6, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    760
    cPanelMichael
    Feb 8, 2016
  5. urgido

    problem with mysql on restored process from cpmove file

    urgido, Aug 22, 2015, in forum: Database Discussions
    Replies:
    9
    Views:
    865
    cPanelMichael
    Sep 4, 2015

Share This Page