How to restore a backup?

THE_EGO_CORPORATION · July 23, 2020, 4:47pm

I m using ERPNext on my windows 10 in Virtual box.
I was taken backup resently in my pc. And backup file in my PC’s folder. So now how i backup. I try some way but show some error like SQL_FILE_MISSING.
SO please give me solution.

krnkris · July 23, 2020, 6:14pm

@THE_EGO_CORPORATION

Welcome!

Please take a look on the official page:

Restoring From ERPNext Backup · frappe/erpnext Wiki · GitHub

Hope it helps!

venkatesh · July 24, 2020, 4:14am

copy unzipped backup file to backup folder in virtual machine through filezilla/WinSCP and restore by
bench --site [sitename] --force restore /path/to/SQLFILE

THE_EGO_CORPORATION · July 24, 2020, 8:14am

Sir How to know [sitename]?

venkatesh · July 24, 2020, 8:24am

default site name is site1.local
so path is
bench --site site1.local --force restore /path/to/SQLFILE

otherwise site name u can get from frappe-bench/sites folder

THE_EGO_CORPORATION · July 25, 2020, 2:05pm

I was try please suggest any video tutorial?

venkatesh · July 26, 2020, 5:44am

mymi14s · July 26, 2020, 8:19am

your site name is in your bench directory
sites/

Locate the backed up files or chech
sites/sitename/private/backups

You’ll find 3 files
Database, file, private file.

Copy to an external folder.

Then go back to bench folder
execute
bench --site sitename --force restore path-to-the-database-file

Tech_Hack_IT · February 6, 2021, 5:59am

Refer this video for restore/backup