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 to get/restore a mysql table only, from WHM backup

Discussion in 'General Discussion' started by basketmen, May 21, 2012.

  1. basketmen

    basketmen Well-Known Member

    Joined:
    Sep 9, 2010
    Messages:
    122
    Likes Received:
    0
    Trophy Points:
    66
    Hi guys,

    i have standart WHM backup, that set daily

    now i need to get/restore a mysql table only,

    how to do that, or where is the path to get this mysql table in ssh, its ok if i need to download the entire mysql file, not a table only
     
    #1 basketmen, May 21, 2012
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    42,802
    Likes Received:
    1,714
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello :)

    If you only configured your backups to save account backups, then you can find the backup file for the account at:

    /backup/cpbackup/daily/username.tar.gz

    Simply extract this file to a temporary location, and you will find the MySQL databases at the following path:

    /temporary/path/username/mysql/database.sql

    Thank you.
     
    #2 cPanelMichael, May 23, 2012
(You must log in or sign up to post here.)
Loading...
Similar Threads - restore mysql table
  1. sodapopinski

    Restore mysql database to server with maria DB?

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

    Restore backups/import without MySQL resetting mysql passwords?

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

    How to restore all files backups and a mysql separately?

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

    Mysql Always Restarting During Full Backup Restore

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

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

    djbaxter, Mar 11, 2017, in forum: Data Protection
    Replies:
    11
    Views:
    1,932
    cPanelMichael
    Dec 18, 2017

Share This Page