Backing up database data from a Crypt server

This is really just a step-by-step version of what’s available in the July 2015 update doc, which links to Django dumpdata and loaddata.

If you want back up your Crypt server database, this is how you can dump the data out:

docker ps

to find the name of your docker container, in case you forgot it? Let’s just assume, for the next command, that the container’s name is Crypt.

docker exec -it Crypt bash

This gets you to a bash prompt inside the Crypt docker container.

cd /home/docker/crypt/

Change to the docker crypt directory.

python manage.py dumpdata > db.json

Dump the data out into a .json file.

exit

Exit out of the docker container bash shell.

docker cp Crypt:/home/docker/crypt/db.json .

Copy the .json file to where you are outside the docker container.

If you want to get back into the docker container to delete the original .json (since there is no docker mv, only docker cp), you can do

docker exec -it Crypt bash
rm /home/docker/crypt/db.json
exit

P.S. Thanks to Graham Gilbert for the tip about not needing to chmod the manage.py file.

P.P.S. This data dump method will work regardless of whether you’re using the built-in sqlite3 database or an external postgresql database.


Posted

in

by

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *