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!

Automate mysql database backups

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

  1. zerpex

    zerpex Member

    Joined:
    Oct 17, 2011
    Messages:
    18
    Likes Received:
    0
    Trophy Points:
    51
    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:
    16,429
    Likes Received:
    415
    Trophy Points:
    583
    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?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

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.
    Dismiss Notice