Upgrade Storagezotero.sqlite damaged and backup [SOLVED]
Hi everyone,
My zotero.sqlite has been damaged recently and I haven't been able to use the zotero database repair tool (https://www.zotero.org/utils/dbfix/) because my zotero folder is >150 MB (4.8GB) with all the PDFs. I ran the repair tool on the zotero folder without the storage folder, it gave me a 0 byte sqlite file... which I used to restart zotero.
This led to the lost of indexes for all the paper downloaded and added to zotero since April 2020 (not suprising).
But I still have the folders and the PDFs downloaded between April and July.
I would like to know if there is a chance to recover the indexes (if it's the right term) from the damaged sqlite file and to add it to the new sqlite files which works well despite the loss. (I have a copy of both).
Thank you very much for your help and if you have other ideas let me know.
Victor
My zotero.sqlite has been damaged recently and I haven't been able to use the zotero database repair tool (https://www.zotero.org/utils/dbfix/) because my zotero folder is >150 MB (4.8GB) with all the PDFs. I ran the repair tool on the zotero folder without the storage folder, it gave me a 0 byte sqlite file... which I used to restart zotero.
This led to the lost of indexes for all the paper downloaded and added to zotero since April 2020 (not suprising).
But I still have the folders and the PDFs downloaded between April and July.
I would like to know if there is a chance to recover the indexes (if it's the right term) from the damaged sqlite file and to add it to the new sqlite files which works well despite the loss. (I have a copy of both).
Thank you very much for your help and if you have other ideas let me know.
Victor
Did you make a backup of your data directory before using the repair tool, as the instructions say?
What's the size of your (non-0-byte) zotero.sqlite, and what exactly happens now if you zip it and upload it to the repair tool? Can you provide an Upload ID from the tool?
I thought "database" was referring to the whole zotero folder, my bad.
I do have a backup of my data directory.
Here is the upload ID of the new repair :
5f1706aa2c721
The former sqlite file is 82 972 KO
The new sqlite file (repaired and unzipped) is 80110 KO
Should I try to restart Zotero with this new SQFILE ?
Victor
Victor