Partner - Restore Backup in ERPNext

• Unzip files (this step is not necessary for the latest version)

gunzip [DATABASE BACKUP FILE.sql.gz]
tar xvf [FILES BACKUP.tar]

• Go the bench folder, which is usually frappe-bench
• Run the following bench commands to restore your database and files

bench --site [sitename] --force restore [path to database backup file] --with-private-files [relative-path-to-private-files-backup-file] --with-public-files [relative-path-to-public-files-backup-file]

• [sitename] - the name of the working site to which you want to restore your data.
• [path to database backup file] - path to database backup file that you downloaded (this path should be a relative path from the current bench directory). The name of this file usually ends with ...-database.sql.gz
• [relative-path-to-private-files-backup-file] - path to private files backup file that you downloaded (this path should be a relative path from the sites directory). The name of this file usually ends with ...-private-files.tar
• [relative-path-to-public-files-backup-file] - path to public files backup file that you downloaded (this path should be a relative path from the sites directory). The name of this file usually ends with ...-files.tar

Restoring only the database

• If you prefer to restore only the database, you can do so by running the following bench command.

bench --site [sitename] --force restore [path to database backup file]