May 26, 2010 @ 5:56PM
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
Get all outdoorsy with Pentax's Optio WG2 and WG2-GPS
Canon's complement of compacts
Compact cameras: down, but not out
How to use a grey card
Nikon PB4 Bellows Reborn
Worlds Fastest Camera
The New Sony NEX 7
Photojojo iPhone Telephoto Lens review — AudioCast
Photo Accessories that Fail Security Checks
My week with Q
Studio equipment buying guide for beginners
VSCO Film Studio Review
Photo Tips
Lessons in Lighting
Photographing Children in the wedding party
Cattle Country
Creative Photo Valentine Surprise
How to Use Multiple Lights for Dramatic Portraits
Making your own flash diffuser
LR4 free presets: Faded series
Using Sync for Video in Develop
A gift of flowers: unfold your senses
On Set of "Love & Robots" the Film
My Night with Ilford Galerie Gold Silk Fibre
FOTOMOTO - Why I Left











Silhouettes & Photo Contests
Cyan, not just another color
Our 26 best photo projects of 2011
Family Ties That Bind
Animal Group Portraits
A Brief History Of Light & Photography: Part 3 of 3
A Brief History Of Light & Photography: Part 2 Of 3
Lightroom Interview: Kevin Tieskoetter
Always Dream Big
Gallery: Embedded with the Territorial Army
Getty Villa Malibu — 4 Old Faces, 1 Sunken Garden — GALLERY (6 photos)
Going Fast with Light
Wildlife photography for the masses
How much should you charge for a photograph?
Santa Pictures + Marketing for your Business


































Comments
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.
- 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