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.

Automate mysql database backups

Discussion in 'Database Discussions' started by zerpex, Oct 20, 2011.

  1. zerpex

    zerpex Member

    Joined:
    Oct 17, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Hello Everyone,

    I'm using the WHM Backup function to take backup of the user accounts, storing them on my 2nd drive.

    But is there any way, I can create a script / cron for the server that once a week, take all databases and make a backup? and store it in etc /backup/mysql/maybe_date_time.AccountName.sql ? because I'm using an external offsite service, that takes backup of the server running in the background anyway, but I want to be able having those backups of whole cpanel accounts on my 2nd drive..

    So etc, Sunday night it takes backup of cpanel accounts, store them to /backup as usual..

    But then friday night it takes backup of databases and store them in /backup/mysql
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,451
    Likes Received:
    195
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    You're not backing up databases when cPanel Backup runs?

    I seem to recall several threads on this sort of topic, wanting a separate script to do DB backups to another server. Have you checked the forums at all?
     
Loading...

Share This Page