I am using Erpnext Cloud right now and have also set up a self-hosted server through the digital ocean using frappe docker. Everything is running well on the server but I am not a user of how to restore the Erpnext cloud database to that server. I have installed the system using
ERPNext is a free, self hosted, open source ERP System that is Enterprise and Production ready. - YouTube.
If there are some default steps to restore the Sql.gz data to docker.
I am using ubuntu
you need 4 files to restore backup in general:
- sql.gz backup
- private files tar
- public files tar
- site_config.json (need “encryption_key” from here)
- restore sql file to database.
mysql -uroot -p$PASSWORD db_name < db_file.sql
- remove the extra installed apps (if restoring from frappecloud/erpnext.com)
bench --site <site.name> remove-from-installed-apps journeys
bench --site <site.name> remove-from-installed-apps erpnext_support
- you may have to remove extra doctype and module def for Journeys and ERPNext Support apps. Remove using sql query or bench console.
- After restore, run
bench --site <site.name> migrate
Note: for all these operations you need to exec into the erpnext-python container.
Thank You very much for indicating the steps. Was able to do it on the first go!!!
I have same problem can you explain step by step docker restoration database?