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:
    38,165
    Likes Received:
    1,371
    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. postcd

    Restore backups/import without MySQL resetting mysql passwords?

    postcd, Aug 30, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    102
    cPanelMichael
    Aug 31, 2017
  2. postcd

    How to restore all files backups and a mysql separately?

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

    Mysql Always Restarting During Full Backup Restore

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

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

    djbaxter, Mar 11, 2017, in forum: Data Protection
    Replies:
    8
    Views:
    1,412
    cPanelMichael
    Apr 4, 2017
  5. cornishman33

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    437
    cPanelMichael
    Oct 11, 2016

Share This Page