Creating Backups / Operator's Guide to the Database

[brick-brick-brick]

What is the correct way to create a backup of a Darkflame Universe instance?

After a (very) brief look at the technical docs and the Mythran's Bible I didn't yet figure out how to correctly create a full backup of the game data. What i currently do is a mysqldump -uroot -pmypasswordhere --all-databases but is that enough? I've seen that there is also a sqlite database in use but I'm not sure whether that contains any save game data or if that is only reference data.

I think it could be good if the Mythran's Bible could contain a section on how to create and restore backups and maybe some more info on how to operate the database. e.g. if i have a DB dump from yesterday and a player has accidentally deleted their character since then how do I restore just that character without undoing other players progress since then and tasks like that?

Thank you for providing this very useful resource!