How to Restore Backup From Erpnext Cloud Platform to local vm

Mohamed_Sheir · April 11, 2020, 2:42pm

How Can I fill this command
bench --site site_name --force restore /path/to/copied/latest_date_time_sql.gz

how I can get the path?
my backup file
20200411_060030_sql.gz downloaded from the cloud platform, to the desktop
thank you in advance

hendrik_zeta · April 11, 2020, 3:20pm

Usually I always put the backup file in the frappe-bench folder in vm, so I just need to do bench --site site_name --force restore latest_date_time_sql.gz

Mohamed_Sheir · April 11, 2020, 7:38pm

how I can do this? to save the back up file in the bench folder ?

smino · April 11, 2020, 9:05pm

What is the local vm and what OS is the workstation where the backup file is now? You might be able to use sshfs to mount the vm filesystem to the workstation and copy it. You could also give the vm access to its host USB ports and copy the files to a USB drive etc. Or use a shared folder .

Mohamed_Sheir · April 11, 2020, 11:04pm

I tried to copy the path from the shared folder but it referes that invalid location anyhelp??

Appreciate your help

sanjay · April 12, 2020, 5:31am

zcat /path/to/copied/latest_date_time_sql.gz | mysql -u<user> -p<password> <database>

Mohamed_Sheir · April 17, 2020, 9:57pm

I copy this code as it is ?

Muzzy · April 19, 2020, 9:12pm

If you are on Windows PC then try WinSCP GUI to download and save the file.