search

DPIclimate / broker

3 stars 3 forks source link

Make db backups easier to use #49

Open dajtxx opened 12 months ago

dajtxx commented 12 months ago

Change the backup script to:

  1. Only export data, not create tables etc.
  2. Split the backup into 2 files - one with everything other than the sources and message tables, and the other with the message tables. The sources table is pre-populated by the db creation script so must be skipped in the data-only backup.

This will allow us to copy the backups into the init.db directory and if they are named appropriately they will run after the db creation script.