This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

Re: Fine tuned MySQL database backups

3 posts / 0 new

Topic locked

Last post

#1 Mon, 10/24/2016 - 11:22

sespit

Re: Fine tuned MySQL database backups

Hello,

I love the way Virutalmin makes backing up MySQL database on a simple schedule easy. However, we now would like to have more fine tuned backups. I would like to keep one snapshot a month indefinitely, but have the last 3 days of nightly snapshots at any given time. Even just having something like the last three nightly and the last 3 first-of-the-month snapshots would be great.

I can't seem to figure out a way to do this through the MySQL module in Virtualmin. Any pointers would be great.

Thank you!

Ryan

#2 Mon, 10/24/2016 - 17:10

lolbrol

Maybe a solution

Configure 2 shudeled backups:

Virtualmin -> Backup and Restore -> Scheduled Backups --> Add a new backup schedule

1) Virtual servers: select the virtual server to backup

2) Features and settings: select Only those selected below -> select Contents of server's MySQL databases

3)Destination and format: Delete old backups -> for one shedule you chose never and for the other after 3 days

4) Schedule and reporting: configure a simple schedule or complex schedule

#3 Tue, 10/25/2016 - 10:43

sespit

I'll try this. Thanks!

Topic locked