Speed up bench restore / automatic restore

[Steven_Athouel]

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

[revant_one]

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.

Has anyone ever successfully moved a working ERPNext system to another server without using a server image?

I have multiple sites on single vps, moving them one by one is time consuming. For moving files and database in a single command I use rsync. For database: ssh keys need to be configured for this to work Execute on source and target machine to stop mariadb sudo systemctl stop mariadb Execute on source machine to move database files sudo rsync -avz /var/lib/mysql/* user@example.com:/var/lib/mysql/ Execute on target machine set ownership and restart mariadb sudo chown mysql:mysql -R /var…