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
     
    #1 jsteel, Sep 16, 2002
  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
     
    #2 itf, Sep 16, 2002
  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.
     
    #3 albertg, Sep 18, 2002
  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
     
    #4 jsteel, Sep 18, 2002
  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?
     
    #5 TheVoice, Sep 20, 2002
  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/
     
    #6 itf, Sep 20, 2002
(You must log in or sign up to post here.)
Loading...
Similar Threads - MySQL Backups via
  1. oprezy

    how can i set the max of mysql connection number

    oprezy, Aug 3, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    84
    cPanelMichael
    Aug 3, 2016
  2. electric

    How to install mysql that was previously removed?

    electric, Jul 12, 2016, in forum: General Discussion
    Replies:
    5
    Views:
    146
    cPanelMichael
    Jul 14, 2016
  3. jazbek

    Install mysqli without EasyApache

    jazbek, Jun 23, 2016, in forum: General Discussion
    Replies:
    6
    Views:
    486
    cPanelMichael
    Jun 24, 2016
  4. Tom Risager

    The MySQL service is currently configured to listen on all interfaces

    Tom Risager, May 20, 2016, in forum: General Discussion
    Replies:
    23
    Views:
    4,171
    cPanelMichael
    Jul 14, 2016
  5. psm

    Out of memory: The process “mysqld” was terminated because the system is low on memory

    psm, May 18, 2016, in forum: General Discussion
    Replies:
    3
    Views:
    523
    cPanelMichael
    May 30, 2016

Share This Page