Installed ERPNext via docker (not bench), I can't find the database anywhere

#1

Hello,

I have installed ERPNext via docker (not bench), and I can’t find the database anywhere.

I knew the database name and password from the .json file, but I don’t know where to find it exactly.
The server only shows:
[information_schema]
[mysql]
[performance_schema]
[sys]

I am able to backup my files, but I need to backup the database also. Any recommendation?

Thanks.

#2

Docker spell:

docker ps

It will list running containers.

Backup section in docs : frappe_docker/site-operations.md at main · frappe/frappe_docker · GitHub

#3

Thank you much Revant for reply.

May I ask what is meant by

"<project-name>"

in the code of docker backup?

Thank you

#4

The name given to the project by docker-compose --project-name

By default it’ll take directory name where docker-compose was executed.

#5

Thank you very much for replying

It gives me an error every time I try to execute the code. = frappe_docker

It says it doesn’t find the directory:
/home/frappe/frappe-bench/sites

can you please give me an example of code can be executed.

docker run \ -e "SITES=site1.domain.com:site2.domain.com" \ -e "WITH_FILES=1" \ -v <project-name>_sites-vol:/home/frappe/frappe-bench/sites \ --network <project-name>_default \ frappe/erpnext-worker:$VERSION backup

#6

All docker containers need to be started before running site creation command. Are all containers running?

#7

Yes, all containers are running

#8 
docker volume ls

Use the volume listed here in the backup command.

  1. Play with docker is working, just tried now. Play with Docker
  2. It could create backup and restore in tests Travis CI - Test and Deploy with Confidence

I don’t know what is happening on your machine.