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 Backups via WHM

Discussion in 'General Discussion' started by jsteel, Sep 16, 2002.

  1. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Atlanta, GA
    What is located in the '_var_lib_mysql.tar.gz' backup file that WHM creates? Is it a complete backup of all MySQL data? I want to make sure I have backups of all MySQL data for my users should anything catastrophic happen.

    Jaz
     
    #1 jsteel, Sep 16, 2002
  2. itf

    itf Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    624
    Likes Received:
    0
    Trophy Points:
    316
    [quote:ec445bff5c][i:ec445bff5c]Originally posted by jsteel[/i:ec445bff5c]

    What is located in the '_var_lib_mysql.tar.gz' backup file that WHM creates? Is it a complete backup of all MySQL data? I want to make sure I have backups of all MySQL data for my users should anything catastrophic happen.

    Jaz[/quote:ec445bff5c]
    It is what you have in /var/lib/mysql/ directory means all of your MySQL tables and data
     
    #2 itf, Sep 16, 2002
  3. albertg

    albertg Well-Known Member
    PartnerNOC

    Joined:
    Sep 4, 2002
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    156
    So any idea how can i backup those files in there...perhaps...maybe to my own computer....
    Just incase something bad happen.

    Thanks.
    or any other ways for me to backup my clients DB would be appreciated.

    Thanks.
     
    #3 albertg, Sep 18, 2002
  4. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    166
    Location:
    Atlanta, GA
    That was the point of my question. If you have backups enabled in WHM, the '_var_lib_mysql.tar.gz' that gets created is the backup of the data. Simply download it to your machine to have a local backup.

    Jaz
     
    #4 jsteel, Sep 18, 2002
  5. TheVoice

    TheVoice Well-Known Member

    Joined:
    Feb 7, 2002
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    316
    where is this tar.gz for mysql located when whm makes it I can't seem to find it anywhere?
     
    #5 TheVoice, Sep 20, 2002
  6. itf

    itf Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    624
    Likes Received:
    0
    Trophy Points:
    316
    [quote:80c8e80091][i:80c8e80091]Originally posted by TheVoice[/i:80c8e80091]

    where is this tar.gz for mysql located when whm makes it I can't seem to find it anywhere?[/quote:80c8e80091]
    if you have Backup feature enabled then

    /backup/cpbackup/*/dirs/
     
    #6 itf, Sep 20, 2002
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL Backups
  1. rinkleton

    SOLVED Backups missing mysql files

    rinkleton, Oct 3, 2017, in forum: Data Protection
    Replies:
    9
    Views:
    111
    cPanelMichael
    Oct 6, 2017
  2. postcd

    Restore backups/import without MySQL resetting mysql passwords?

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

    How to restore all files backups and a mysql separately?

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

    Mysql backups

    _Chris_, Oct 4, 2016, in forum: Data Protection
    Replies:
    5
    Views:
    492
    cPanelMichael
    Oct 10, 2016
  5. bluecup

    How to download MySQL database backups based on backup dates?

    bluecup, Aug 16, 2016, in forum: Data Protection
    Replies:
    3
    Views:
    604
    Infopro
    Aug 16, 2016

Share This Page