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!

MySQL Database Restoration from Full Backup

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

  1. osirion

    osirion Well-Known Member

    Joined:
    Jan 16, 2007
    Messages:
    50
    Likes Received:
    4
    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:
    267
    Likes Received:
    20
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 Eminds, Jun 14, 2017
  3. osirion

    osirion Well-Known Member

    Joined:
    Jan 16, 2007
    Messages:
    50
    Likes Received:
    4
    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 Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,803
    Likes Received:
    1,898
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, Jun 14, 2017
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL Database Restoration
  1. BluePlanet

    New Thread Run a MySQL query on database on different cPanel account

    BluePlanet, Oct 19, 2018 at 9:35 AM, in forum: Database Discussion
    Replies:
    0
    Views:
    32
    BluePlanet
    Oct 19, 2018 at 9:35 AM
  2. steven_h

    The system failed to connect to the MySQL database issue

    steven_h, Sep 11, 2018, in forum: Database Discussion
    Replies:
    2
    Views:
    224
    steven_h
    Sep 18, 2018
  3. Daniel Enriquez

    Creating mysql databases with xmlapi.php issue

    Daniel Enriquez, Aug 21, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    154
    cPanelMichael
    Aug 22, 2018
  4. Peter Sampson

    Using PHP to create Mysql databases issue

    Peter Sampson, Aug 21, 2018, in forum: cPanel Developers
    Replies:
    1
    Views:
    138
    cPanelMichael
    Aug 22, 2018
  5. ANOUCHKA MINKOUE OBAME

    SOLVED No File Manager or MySQL Databases Tools?

    ANOUCHKA MINKOUE OBAME, Jul 25, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    194
    cPanelMichael
    Jul 25, 2018

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.
    Accept Learn More...
    Dismiss Notice