ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Speed up bench restore / automatic restore

Hi,
I want to set a Sandbox version of my production frappe site in order to perform test.
Do you know how i can set up an automatic DB replication from my production DB to my sandbox DB let’s say every week for example ?
Using bench restore command is too slow and i don’t know how to automate this.

Thanks

mysqldump was very slow for me to copy large database.

Try some kind of volume snapshots. This is the fastest way I was able to copy database to another server.