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.

remote backup several database from one account?

Discussion in 'General Discussion' started by Quuipo, Oct 6, 2006.

  1. Quuipo

    Quuipo Registered

    Joined:
    Aug 25, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151
    hi,

    i'm looking for a way to setup a daily backup of 2 or 3 databases ONLY in the account of an user.

    Right now it will backup and ftp ALL databases, which is too much, i only need 2 (in the future 3) databases from that account.


    Is it possible to select what databases it should backup?

    thanks,
    Q
     
    #1 Quuipo, Oct 6, 2006
  2. erick_paper

    erick_paper Well-Known Member

    Joined:
    Apr 19, 2005
    Messages:
    245
    Likes Received:
    0
    Trophy Points:
    166
    You can write a simple crontab script with the command MYSQLHOTCOPY. Check Mysql site documentation for the command. It backs up huge databases (1.5 million records and growing) in 2-3 seconds.
     
    #2 erick_paper, Oct 6, 2006
  3. Quuipo

    Quuipo Registered

    Joined:
    Aug 25, 2006
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    151

    thank you, i will look into it.

    can it ftp to a remote location as well? since i'm looking for a solution that will automatically back them up and ftp to a remote location.

    i'm not much of a scripter, that's why i hoped this was possible with Cpanel.
     
    #3 Quuipo, Oct 7, 2006
(You must log in or sign up to post here.)
Loading...
Similar Threads - remote backup several
  1. jndawson

    Backup to remote has auth issues

    jndawson, Jun 21, 2017 at 3:17 PM, in forum: Data Protection
    Replies:
    6
    Views:
    53
    cPanelMichael
    Jun 23, 2017 at 11:45 AM
  2. Andrew Davis

    Multiple Remote Incremental Backups

    Andrew Davis, May 28, 2017, in forum: Data Protection
    Replies:
    8
    Views:
    172
    Andrew Davis
    May 31, 2017
  3. postcd

    Restore a Home Directory Backup to Remote Server

    postcd, Mar 23, 2017, in forum: Data Protection
    Replies:
    1
    Views:
    216
    cPanelMichael
    Mar 24, 2017
  4. Dane Agathon

    SOLVED Weekly backups not being removed after remote backup

    Dane Agathon, Dec 28, 2016, in forum: Data Protection
    Replies:
    5
    Views:
    598
    Dane Agathon
    Jan 17, 2017
  5. craigedmonds

    Backup Process Errors due to MySQL DB being remotely hosted

    craigedmonds, Dec 22, 2016, in forum: Data Protection
    Replies:
    1
    Views:
    236
    cPanelMichael
    Dec 22, 2016

Share This Page