Upgrade Storage188BET靠谱吗Database size changed after manual repair of zotero.sqlite!possibility of data loss?
This is a follow up of
188BET靠谱吗https://forums.zotero.org/discussion/104649/.
188BET靠谱吗Immediately after running "sqlite3 zotero.sqlite < dump.sql" following 188BET靠谱吗//www.brodersterzo.com/utils/dbfix/manual188BET靠谱吗, the size of zotero.sqlite was increased by about 3~4 MB.188BET靠谱吗However, after reopening Zotero to load the database, its size was decreased by about 15~20MB.188BET靠谱吗Even though the database integrity is OK after the manual repair, I'm still worried about the possibility of data loss when running the "sqlite3 zotero.sqlite .recover > dump.sql" to recover all the data from scratch.So is there any method to check for possible data loss during the manual repair by running the commands in 188BET靠谱吗//www.brodersterzo.com/utils/dbfix/manual?
188BET靠谱吗Immediately after running "sqlite3 zotero.sqlite < dump.sql" following 188BET靠谱吗//www.brodersterzo.com/utils/dbfix/manual188BET靠谱吗, the size of zotero.sqlite was increased by about 3~4 MB.188BET靠谱吗However, after reopening Zotero to load the database, its size was decreased by about 15~20MB.188BET靠谱吗Even though the database integrity is OK after the manual repair, I'm still worried about the possibility of data loss when running the "sqlite3 zotero.sqlite .recover > dump.sql" to recover all the data from scratch.So is there any method to check for possible data loss during the manual repair by running the commands in 188BET靠谱吗//www.brodersterzo.com/utils/dbfix/manual?
If the database is working at all, it's fairly unlikely that you'd be missing any visible data (items, collections, etc.).The corruption was most likely in an index, which can be rebuilt without any data loss.
Even if it was in a data table itself, it would've most likely been in the full-text-search tables.If you find that Everything/Attachment Content searches aren't matching items, you could rebuild the index from the Search pane of the preferences, but I wouldn't worry about it now.