sqlite files

mkostura · March 30, 2020

I create backup copies of my Zotero data base on occasion and I have noticed in this last go round that I had four versions of the Zotero sqlite database file. Not causing a problem that I am aware except for the backup software which has tagged these files as additional from the previous image. What sglite files can I retain? I presume zotero.sglite and zotero.sqlite.bak. Can the others be deleted?

dstillman · March 30, 2020

zotero.sqlite is your active database, zotero.sqlite.bak and zotero.sqlite.1.bak are automatic daily backups, and zotero.sqlite.[higher number].bak is from the last time Zotero upgraded the database.

If you're making regular, automated backups of the data directory — e.g., every hour — you could consider disabling the automatic backups by changing extensions.zotero.backup.numBackups to 0 in the Config Editor in the Advanced pane of the Zotero preferences.