Changes between Initial Version and Version 1 of Ticket #366
- Timestamp:
- 10/11/06 05:06:25 (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #366 – Description
initial v1 1 1 Slight flaw in the current backup strategy: if you corrupt your SQLite DB while Firefox is open, Zotero will happily copy the corrupted file to the backup file, leaving you with two worthless files. 2 2 3 Unfortunately the caching prevents us (as far as I can tell) from actually determining if the DB on disk is corrupt or not after we've first opened a working one, even if the connection is manually unset. And there doesn't seem to be a way to do a .dump from mozStorage, which would solve all our problems.3 Unfortunately the mozStorage caching prevents us (as far as I can tell) from actually determining if the DB on disk is corrupt or not after we've first opened a working one, even if the connection is manually unset. And there doesn't seem to be a way to do a .dump from mozStorage, which would solve all our problems. 4 4 5 5 If we were OK with requiring storage space for three copies of the DB, we could back up pre-connect at startup to a temporary file, try to open the main DB, if successful replace the last shutdown backup with the new one, and otherwise delete the new startup backup and try to restore from the shutdown. Then at shutdown move the startup backup down one and make a copy of the DB, which may or may not be corrupt, but at least we then have protection for corruption both when Firefox is running and when it's not.