Additional MySQL backup during the day

[cosmin]

Hi!

I want to make local on backup hdd another 1-2 full mysql backup during the day. A cron job to run every x hours and make a new backup but not incremental for all /var/lib/mysql. I want to have last x backups and after that the script can remove the oldest and make the new one.
Any ideea about a script to do that? I don't want a mysqldump, I prefer a backup for all folder.
cPanel backup script can do this (if I choose this option form WHM) but I don't know how.

Many thanks!

 

[cPanelLauren]

Hello @cosmin

The cPanel backup uses mysqldump to do both the partial and full backups. If you wanted to create additional full backups you can modify the cron times for the following cron:

/usr/local/cpanel/bin/backup

If you wanted to do a per account full backup you could use the UAPI:

UAPI Functions - Backup::fullbackup_to_homedir - Developer Documentation - cPanel Documentation

Otherwise you'd need to use mysqldump to backup just the databases.


Thanks!