A backup from an SQL file

[ederollora]

Hi!

I am new to this group. I have an automation script that gets an SQL file in a day or so. This dumped file, may be similar to the JSON file; I have not checked it. Also, I cannot find any backup of the media, unfortunately.

I did not know anything about invoke backup/restore (my bad).

And the backup_automation_script.sh should be run once a day/week or so. If you "fuck up" the container and you did not do the export to an .SQL file, then you are going to lose all the information. I am using docker, by the way.

You need to have the default version in docker:

• docker-compose.yml
• Caddyfile
• .env

The steps are:

echo "Creating a backup of the PostgreSQL database..."
sudo docker exec $CONTAINER_ID pg_dump -U $DB_USER -d $DB_NAME > "$BACKUP_DIR/${DB_NAME}_backup_${DATE}.sql"

or

sudo docker exec -it invenTree-db pg_dump -U postgres inventree > inventree_backup.sql

Once you have the inventree_backup.sql in the host machine, you create the invoke update in the inventree-server:

sudo docker-compose run --rm inventree-server invoke update # I am using the old docker-compose

After it is done, we go to the inventree-db, but to the postgres database.

sudo docker exec -it inventree-db /bin/bash
root@90547a203259:/#  psql -U pguser postgres

Then we DROP and CREATE the database inventree. Whatever you had done in the inventree, we drop it.

postgres=# DROP DATABASE inventree;
DROP DATABASE
postgres=# CREATE DATABASE inventree;
CREATE DATABASE

root@90547a203259:/# exit
exit

Then we run:

sudo docker exec -i inventree-db psql -U pguser inventree < ./inventree_backup.sql

Then we start the container:

sudo docker-compose up -d

This should be it. Maybe you have another version or another way to solve the problem. I did try to look for an inventree SQL or Google search, nothing came up. Even in this Inventree Github discussion forum.

If you see any errors, let me know.

Cheers