Database restore on schedule

Submitted by masterg0g0 on Mon, 11/05/2018 - 16:19 Pro Licensee

Hello,

So i have use case,, There is a database in one of my websites which needs to be restored every week on a particular day. I understand i can take a schedule backup but can i not restore also on a schedule?

I have read and done internet search but not find proper help. is this somekind of limitation that we have in Virtualmin or was it never requested?

Thanks, Rohit

Status: 
Active

Comments

Submitted by andreychek on Mon, 11/05/2018 - 16:25

Howdy -- thanks for contacting us!

While scheduled backups are a feature of Virtualmin, there isn't a way to automatically restore them from within the GUI.

However, it's no problem to do so using the command line tools, which you can then add to cron.

To see the restore syntax, try running this command as root:

virtualmin restore-domain

That'll show you the various options... once you find the options that work the way you need, you can then add the command into a scheduled cron job.

Submitted by masterg0g0 on Mon, 11/05/2018 - 17:01 Pro Licensee

When backups can run in background and there is no GUI involved there, can we not do this for restore function?

Or just provide a button with link to " setup as cron" under restore function? it would good feature you see :)

Submitted by andreychek on Mon, 11/05/2018 - 22:22

Well, automated restores are not really a feature most folks need, and we're already looking for ways to remove some options from the GUI... we have a few too many and that can confuse some people.

The best way to do that would be to determine what command line offers what you need there. Once you have that working on the command line, add that into Webmin -> System -> Scheduled Cron Jobs using your desired schedule.