i tried to backup the erpnext v14 in docker
$ docker compose --project-name erpnext-one exec backend bench --site one.mysite.in backup
i got the backup file 20230420_204703-one_mysite_in-database.sql.gz
then i tried
$ gunzip 20230420_204703-one_mysite_in-database.sql.gz
i got the .sql file
when i try to restore the file
$ docker compose --project-name erpnext-one exec backend bench --site one.mysite.in --force restore 20230420_204703-one_mysite_in-database.sql
but i got
Invalid path 20230420_204703-one_mysite_in-database.sql
to which path i have to restore the .sql file in docker based erpnextv14 installation
try full path to the file.
the command prompt executes from
the frappe commands generally execute under
just the filename is taken as relative path.
issue fixed , refered your solution
login to frappe container
cp 20230420_204703-one_mysite_in-database.sql.gz /home/frappe/frappe-bench/
bench --site one.mysite.in --force restore 20230420_204703-one_mysite_in-database.sql
it asks for MySQL root password:
then restored works fine
does this migration needed compulsory?
docker-compose --project-name erpnext-one exec backend bench --site one.mysite.in migrate
or it is optional?
depends on schema changes in version upgrade.
if there was upgrade without any schema changes, you can skip.
run it once after restore just to be sure everything gets upgraded.