Automate mysql database backups


Oct 17, 2011
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