Speed up bench restore / automatic restore

[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/* [email protected]:/var/lib/mysql/ Execute on target machine set ownership and restart mariadb sudo chown mysql:mysql -R /var…