Hi all!
I’ve searched the forum but haven’t found anything relevant to what I’m looking for.
Does anyone have a backup program that can back up eg bandwidth db when the node is active?
Thanks for tips
Michael
Unlikely there is a backup program which is able to backup SQLite databases without lose of consistence.
But you may use any, if you believe that it’s worth it.
Please note - the backup of node’s data is useless, as soon as you restore it - the node would be disqualified for losing data since backup.
Many thanks for the tips
Talking only about SQLite databases and nothing else.
Why I ask is that I had a crash on bandwidth db that was beyond repair and lost almost 20TB.
These databases are not vital, if you lose them you can recreate them any time. However, you will lose stat and history.
By the way, if you are on Windows, you can use the integrated Backup called File History. Just add a folder with databases and add all other subfolders to the exclusions list.
Write a script to shutdown node, copy databases, start the node. Run the script on scheduler.
But I would not bother. Databases here are purely cosmetic, pretty useless. You can put them to ram disk if you want, and improve performance: more IOps will be available for actually handling data.