Cron for database backup

Server Config
1

Hello guys,

Is there a way to make a cron - Script, that takes all databases on a server, and back them up to a specific folder? etc /backup/mysql/ ?

I’m using cpanel but I’m using the cpanel backup function already, but it only supports 1 task, so I can’t say sunday night it should backup all user accounts, and friday night, just backup the databases… Which is what I kinda need!

Thank you

2

mysqldump is your friend - using this tool you can dump all databases out to an sql file

You’ll probably have to write a quick script to do this, one that you can then cron.