ERPNext.com Frappe Cloud Support Partners Foundation Frappe School

Restore backup from frappecloud into docker container

As mentioned you’ve docker setup running. https://github.com/frappe/frappe_docker/blob/develop/docs/single-bench.md

  • Download your frappecloud backups.
  • copy files into container
docker cp /path/to/backup.sql <project-name>_erpnext-python_1:/opt
docker cp /path/to/private.tar <project-name>_erpnext-python_1:/opt
docker cp /path/to/public.tar <project-name>_erpnext-python_1:/opt
docker cp /path/to/site_config.json <project-name>_erpnext-python_1:/opt
  • enter the container
docker exec -it <project-name>_erpnext-python_1 bash
  • create new site with source sql, enter passwords as needed
bench new-site freesite.example.com --source_sql /opt/backup.sql
  • display output of site_config and copy it to editor
cat freesite.example.com/site_config.json
{
  ...
}
  • change or add the encryption from the site_config given by frappecloud. 80% probability you’ll corrupt the site_config.json because of Ctrl+D, This is called bash shell if you are interested to learn.
cat > freesite.example.com/site_config.json
{
  ...
}
Ctrl+D
  • confirm updated of site_config
cat freesite.example.com/site_config.json
  • remove installed proprietary apps
bench --site freesite.example.com remove-from-installed-apps erpnext_support
bench --site freesite.example.com remove-from-installed-apps journeys
  • migrate
bench --site freesite.example.com migrate

Note:

  • Replace <project-name> with your project
  • Replace /path/to/.... files with actual paths and file names
  • Replace /opt/backup.sql with actual path and filename of sql file