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:
    16
    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
     
  2. itf

    itf Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    624
    Likes Received:
    0
    Trophy Points:
    16
    [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
     
  3. albertg

    albertg Well-Known Member
    PartnerNOC

    Joined:
    Sep 4, 2002
    Messages:
    61
    Likes Received:
    0
    Trophy Points:
    6
    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.
     
  4. jsteel

    jsteel Well-Known Member

    Joined:
    Jul 4, 2002
    Messages:
    646
    Likes Received:
    0
    Trophy Points:
    16
    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
     
  5. TheVoice

    TheVoice Well-Known Member

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

    itf Well-Known Member

    Joined:
    May 9, 2002
    Messages:
    624
    Likes Received:
    0
    Trophy Points:
    16
    [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/
     
Loading...

Share This Page