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:
    36,275
    Likes Received:
    1,201
    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. Naila

    Mysql Always Restarting During Full Backup Restore

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

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

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

    Restore Database From Remote MySQL

    cornishman33, Oct 7, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    356
    cPanelMichael
    Oct 11, 2016
  4. gnusys

    cPanel account restore does not work for remote mysql profile

    gnusys, Feb 6, 2016, in forum: Database Discussions
    Replies:
    3
    Views:
    720
    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:
    823
    cPanelMichael
    Sep 4, 2015

Share This Page