I'm still very new to all this so hope someone can shed some light on my problem.
I leave my box running 24/7, checking the data each evening to check up on my 'hits', but when I checked this morning I found that the programme had closed and that the data for the last 3 days has vanished.
I believe it's related to the way RadarBox handles the SQLite journal file for the MyLog database.
To quote from the SQLite manual:
"The reason that committing the journal to disk is so important is that if the program or system crashes while the pager is writing the database file, the journal is the only way to restore the database file later on. If the journal's pages weren't completely written to disk before a system crash, then the database cannot be restored fully to its original state, because the journal pages that were in memory were lost in the crash. In this case, you have an inconsistent database at best, and a corrupted one at worst."Those sound like the symptoms you have described, though I could be wrong.
So:
Does the database only save when you exit?
I don't know for sure if that's the case, but certainly exiting the application is one way to be confident that all pending updates have been written to the database on disk.
so should I shut down regularly?
See above.
If I back up mydata and navdata files each day while the software is running will this prevent this from happening again?
If you can see a file called
MyLog.db3-journal in your RadarBox Data folder then there's no way you can be sure that the main MyLog.db3 database has had all the data written to it - best to back up those files
after shutting down the application.
HTH
Dave