Automate mysql database backups

[zerpex]

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

 

[Infopro]

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?