So, I have a weekly full and a daily incremental backup on all virtual servers running every morning at 3AM. The full backups are deleted if they’re older than 15 days, and the daily incremental backups are deleted if they’re older than 8 days.
When the backup runs, is the MySQL dump function always dumping the entire database, regardless of the incremental nature of the backup?
As far as I know, Virtualmin (wisely, in my opinion) does not attempt to detect incremental changes to databases, so they would always be full dumps. If I’m wrong, I’m sure someone will correct me.
Richard
Makes sense since incremental db backups could be a nightmare.
DB is completely dumped. No incremental.
Indeed. Other than taking more space, there’s no downside to full dumps every day that I can come up with.
Richard