May 26, 2010 @ 6: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
Can you fix the focus on a blurry photo after the fact?
The birth of Mirrorless Cameras
The Joy Of Winning A Photo Contest
Choosing your first dSLR camera
New York City can be beautiful!
Choosing the Right Light Stand
Photojojo iPhone Telephoto Lens review — AudioCast
My week with Q
How To Become A Successful Photographer
"When the Wind Stopped" — poem with 4 photos
Creating The New Family Portrait
Tips for Textures
Cast aways - saving those photographic memories
One Man Show: My 25 Years With Digital Photography
Studio, Flash, & Available Light — Three Books Reviewed
Portrait styling: dangerous pairings
Adobe Photoshop CS6 Product Managers Interview Audiocast
A gift of flowers: unfold your senses
On Set of "Love & Robots" the Film
No-Brainer Setup For A Digital Photo Frame Exhibit - Part 3











Planning “National Geographic” style photo travel
Wilderness Travel 1 Rainforests – Essential Gear
Backlighting Basics
What Moves You?
FIGURES IN MOTION: Decades of Evolving Personal Imagery in Photography, Part 7
Lomography Store, Austin, Texas — GALLERY
GALLERY — Up to $1,000 Reward for Cattle Rustlers
25% off on photography eBooks
eyePhone: The eBook for iPhone Photographers
Interview with Harold Davis — Closeup Maestro of Flowers & Water Drops
Interview with Steve Caplin — Photoshop Digital Artist, Commercial Illustrator, & Author
A Brief History Of Light & Photography: Part 3 of 3
A Brief History Of Light & Photography: Part 2 Of 3
Easy technique to select, edit and sequence keywords for web
How much should you charge for a photograph?






























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