Notes: Remember that once you are in trouble, stop and think before you do anything. Some I found through this forum, some by my own searches. After the start I got here, I wanted to help people find resources they might find useful. I found lots of great ideas through the 6 or so years this catalog corruption has been happening to people. Thanks very much to this forum for getting me started.
SQLITE LIGHTROOM MAC DOWNLOAD TRIAL
Devastating to think what I could have lost, and has taken hours of research and trial and error but I have got my catalog back and as far as I can tell, I have not lost anything. Working in LR 4, Win7 64 bit, 4GB RAM, accessing catalog and previews from an external drive, images stored on a multiHD-NAS. If I choose my corrupted catalog following this procedure this will still cause LR to crash. Instead it shows a dialog with a list of available catalogs and an option to create check integrity of each catalog. I'm aware of that holding down the Alt-key (on Win) or Opt-key (on Mac) while simultaneously clicking on the LR icon in the dock cause LR to open but not to open the default catalog. Is there by any chance a way to check integrity or do any other kind of catalogue repair of corrupted catalogs that doesn't open in LR? If I'd been more of a tech-pro I'd might been successful in using sqlite3 or sqlite analyzer to check the database. (My latest backup catalog works just fine though, but lacks quite a few hours of work.)
It is not possible to import any data from the corrupted catalog to a new one. I also need to delete the preference files to start LR again. Trying to open a corrupt catalog of mine makes LR freeze forcing me to kill the actual LR-process to proceed.