An oldie, but perhaps a goodie for some. Johan Attali has done a short post on using SQLite3 to fix a broken catalog. Essentially it does a file copy via sqlite3, but SQLite removes the errors on copy.
For more details, check out: http://www.jjbrothers.net/blog/entry/13#add-13
3 thoughts on “Restoring a broken catalog”
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
– download precompiled binaries for Windows from http://www.sqlite.org/download.html
– put a COPY of your catalog in the same folder as sqlite3.exe
– open a command prompt window in this folder and type:
sqlite3 Boken_Catalog.lrcat .dump >backup.sql
– after sqlite3 finishes creating the dump file type:
sqlite3 new.lrcat <backup.sql
The catalog remedy you posted a link to appears to be for a Mac, just wondered if there is another set of instructions for PC. Have had a couple of recent episodes with catalogs that can’t be repaired.
Sqlite is cross platform, so PC should be similar. I really don’t remember PC CLI stuff anymore (10 years since I switched), so I can’t help. You can find out more from http://www.sqlite.org/. Or try leaving a comment on the actual post.