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!
  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. uk01

    Remote sql server backups

    uk01, May 13, 2018, in forum: Data Protection
    Replies:
    2
    Views:
    45
    uk01
    May 15, 2018 at 10:49 AM
  2. urgido

    Backup remote error

    urgido, May 6, 2018, in forum: Data Protection
    Replies:
    5
    Views:
    64
    cPanelLauren
    May 7, 2018
  3. 8p-design

    Remote backups require local storage

    8p-design, Apr 24, 2018, in forum: Data Protection
    Replies:
    6
    Views:
    115
    8p-design
    Apr 27, 2018
  4. urgido

    remote and local backups

    urgido, Apr 23, 2018, in forum: Data Protection
    Replies:
    6
    Views:
    86
    urgido
    Apr 24, 2018
  5. Rizwan Ghzzaal

    SOLVED Remote Destination is not Sending Backups one by one

    Rizwan Ghzzaal, Feb 18, 2018, in forum: Data Protection
    Replies:
    5
    Views:
    225
    cPanelMichael
    Mar 5, 2018

Share This Page