Create backup from server data

[MR-Os1]

Is there a way to properly backup server's data to a file and restore it?
if it's not, how can we add it?

[jmattheis]

Yes, to back up all traggo data, you can copy the traggo database. All state is in there.

server/.env.sample

Lines 17 to 19 in b707a27

	# the database connection string, differs depending on the dialect
	# sqlite3: path/to/database.db
	# TRAGGO_DATABASE_CONNECTION=data/traggo.db

[oslavq]

Traggo stores all of it's data in a .db (database) file, so backing it up yourself is pretty easy.

cd into traggo data location

make sure you got at least rx permissions for traggo.db and sqlite3 package installed on your system. Use these commands to create a database dump (it will contain all of the data from the database as SQL queries that can be later used to recreate the database)

cd /opt/traggo/data (for you, the folder might be in a different location)
sqlite3 traggo.db
.output dump_name.sql
.dump
exit the sqlite3 shell with Ctrl + C

now you will have a .sql file with all of your traggo data. You can view it as plain text with any text editor

You can find guides online on how to restore from a dump, so i won't write this down here.