Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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. Augusto Will

    Remote Only Incremental Backup

    Augusto Will, Sep 14, 2018 at 5:12 PM, in forum: Data Protection
    Replies:
    1
    Views:
    45
    cPanelLauren
    Sep 17, 2018 at 8:24 AM
  2. Duplika

    Incremental local backups plus disaster remote?

    Duplika, Sep 6, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    61
    cPanelLauren
    Sep 6, 2018
  3. srikanthnavaneetam

    cpbackup_transporter not uploading the files remotely

    srikanthnavaneetam, Jul 24, 2018, in forum: Data Protection
    Replies:
    13
    Views:
    148
    srikanthnavaneetam
    Jul 25, 2018
  4. daflame

    Remote Backup for some accounts only

    daflame, Jul 23, 2018, in forum: Data Protection
    Replies:
    1
    Views:
    89
    cPanelLauren
    Jul 23, 2018
  5. Costas Lazarou

    Could not download backup file; security policy on the remote server forbids it.

    Costas Lazarou, Jul 19, 2018, in forum: Data Protection
    Replies:
    3
    Views:
    121
    cPanelLauren
    Jul 20, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice