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.

MySQL Database Restoration from Full Backup

Discussion in 'Database Discussions' started by osirion, Jun 14, 2017.

  1. osirion

    osirion Active Member

    Joined:
    Jan 16, 2007
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    158
    Hi Guys,
    So I have a customer with a full backup. How do I go about (through WHM or CLI) restoring a specific database within the full backup to his account?
     
    #1 osirion, Jun 14, 2017
  2. Eminds

    Eminds Well-Known Member

    Joined:
    Nov 10, 2016
    Messages:
    211
    Likes Received:
    12
    Trophy Points:
    18
    Location:
    India
    cPanel Access Level:
    Root Administrator
    A full backup means a .tar.gz file , you will have untar the file first >> locate the mysql database.sql file and restore that file to the database , you can get the commands from google so its an easy stuff
     
    #2 Eminds, Jun 14, 2017
  3. osirion

    osirion Active Member

    Joined:
    Jan 16, 2007
    Messages:
    38
    Likes Received:
    2
    Trophy Points:
    158
    Thanks - this is what I ended up doing. Was hoping there was a quicker /easier way for future reference, but guess not.
     
    #3 osirion, Jun 14, 2017
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,419
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm happy to see you were able to restore the database. There's no other method of obtaining the SQL file other than extracting it from the full backup archive unless you have a backup of the database itself.

    Thank you.
     
    #4 cPanelMichael, Jun 14, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL Database Restoration
  1. alandioda

    Unable to connect to my mysql database

    alandioda, Oct 8, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    85
    cPanelMichael
    Oct 9, 2017
  2. mysql4all

    Where are mysql databases located?

    mysql4all, Sep 19, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    153
    cPanelMichael
    Sep 19, 2017
  3. akash7130

    Import database in mysql?

    akash7130, May 19, 2017, in forum: Database Discussions
    Replies:
    1
    Views:
    305
    cPanelMichael
    May 22, 2017
  4. raafat1994

    Problem with MySQL database

    raafat1994, May 3, 2017, in forum: Database Discussions
    Replies:
    2
    Views:
    329
    cPanelMichael
    May 4, 2017
  5. brianmp1

    Switch to Remote MySQL Database

    brianmp1, Mar 3, 2017, in forum: Database Discussions
    Replies:
    3
    Views:
    653
    cPanelMichael
    May 8, 2017

Share This Page