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.

Backup All MySQL Data

Discussion in 'General Discussion' started by Nymph, Jul 16, 2003.

  1. Nymph

    Nymph Member

    Joined:
    Jun 17, 2003
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Is there a way in the cpanel to backup all the data for all accounts or do we have to login to each account to make the backups for the MySQL. I want to be able to have a backup of the MySQL directory only (or a dump) since I already mirror the normal contents to another place...

    cPanel.net Support Ticket Number:
     
  2. reddrake

    reddrake Well-Known Member

    Joined:
    Apr 2, 2003
    Messages:
    79
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Wisconsin,Usa
    If you have backup enabled it will backup sql and there files :)

    cPanel.net Support Ticket Number:
     
  3. Nymph

    Nymph Member

    Joined:
    Jun 17, 2003
    Messages:
    23
    Likes Received:
    0
    Trophy Points:
    1
    Well I wanna backup off site and not on the hd there... And I want it to only update good stuff...

    So I do the following...

    cd /home
    lftp -u login1 backup.site.com
    mirror -R -v -e

    cd /var/lib/mysql
    lftp -u login2 backup.site.com
    mirror -R -v -e

    I have to run this manually every night... or every 2 nights... I guess it backs up the MySQL stuff also but I prefer another way. I like the mirring cause it does not download files which have not been changed...

    cPanel.net Support Ticket Number:
     
Loading...

Share This Page