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. sp3ctre69

    Remote incremental backups - timeouts

    sp3ctre69, Aug 3, 2017, in forum: Data Protection
    Replies:
    14
    Views:
    169
    sp3ctre69
    Aug 9, 2017
  2. jndawson

    Backup to remote has auth issues

    jndawson, Jun 21, 2017, in forum: Data Protection
    Replies:
    7
    Views:
    221
    jndawson
    Jun 28, 2017
  3. Andrew Davis

    Multiple Remote Incremental Backups

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

    Restore a Home Directory Backup to Remote Server

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

    SOLVED Weekly backups not being removed after remote backup

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

Share This Page