Try ERPNext Buy Support Partners Foundation

How to restore a backup?

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.

@THE_EGO_CORPORATION

Welcome!

Please take a look on the official page:

https://github.com/frappe/erpnext/wiki/Restoring-From-ERPNext-Backup

Hope it helps!

1 Like

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

Sir How to know [sitename]?

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

I was try please suggest any video tutorial?

1 Like

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