Restoring a broken catalog

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

Comments

Anonymous
Anonymous

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.

Anonymous
Anonymous

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.

Anonymous
Anonymous

- 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

Question for Windows (XP)
When I type the sentence you wrote it says:
near "sqlite3": syntax error

I typed exactly as you wrote, with all the spaces.
What to do?

Post new comment

Pixiq on Facebook

Join the 10135 Pixiq fans on Facebook

Share

  • Share

Subscribe

Get weekly updates from Pixiq. Short, sweet, and always interesting.