{"id":153,"date":"2011-07-13T12:55:39","date_gmt":"2011-07-13T16:55:39","guid":{"rendered":"http:\/\/www.costain.ca\/?p=153"},"modified":"2013-04-17T10:22:05","modified_gmt":"2013-04-17T14:22:05","slug":"recovering-a-lost-aperture-3-library","status":"publish","type":"post","link":"https:\/\/www.costain.ca\/fr\/2011\/07\/recovering-a-lost-aperture-3-library\/","title":{"rendered":"Recovering a lost Aperture 3 library"},"content":{"rendered":"<p>The battery on my 2008 15&#8243; MacBook Pro is dying an ugly death. Last night the battery level dropped precipitously as I imported pictures from an SD card into Aperture 3. When the battery level reached about 75%, the MacBook shut off in mid-import.<\/p>\n<p>I plugged the computer in and rebooted, expecting to complete the import. Not so. Aperture 3 quit unexpectedly every time I tried to launch it. I ran (or tried to run) the built-in diagnotic trio of Repair Permissions, Repair Database and Rebuild Database\u00a0 by holding down the Cmd-Option combo while starting Aperture. Aperture happily repaired permissions, but quit while trying to repair or rebuild the DB.<\/p>\n<p>I was able to start Aperture with a fresh library, so I determined that it wasn&#8217;t the Aperture prefs or executable that were causing the problem.<\/p>\n<p>But how could I get my 64 GB of photos back in some coherent form? Any attempt to import the contents of the corrupt Aperture Library into a new empty library resulted in &#8220;The Crash.&#8221;<\/p>\n<p>I right-clicked on the Aperture Library and used &#8220;Show Package Contents&#8221; to navigate to the folder containing all of the masters (original JPEGS and RAW files). I decided to import the contents of the Masters folder into a new Library.<\/p>\n<p>This procedure worked, but my Projects and Albums were all still toast, as were my Faces and Places data.<\/p>\n<p>Faced with the prospect of having to restructure my photo library from scratch, I cast about on the Internet and found this little gem, which I want to share:<br \/>\n<a title=\"Aperture 3 rebuild library - SQLITE MISUSE\" href=\"https:\/\/discussions.apple.com\/message\/11683186#11683186\" target=\"_blank\">Aperture 3 rebuild library &#8211; SQLITE MISUSE<\/a><br \/>\nThe procedure outlined in this post basically involves deleting the SQLite database files that make up the Aperture Library and then forcing the Library to rebuild from scratch. I can only surmise that I couldn&#8217;t do this before, because Aperture was choking on the original, corrupted database files while trying to rebuild.<\/p>\n<p>A word to the wise: Always backup your computer.<\/p>","protected":false},"excerpt":{"rendered":"<p>The battery on my 2008 15&#8243; MacBook Pro is dying an ugly death. Last night the battery level dropped precipitously as I imported pictures from an SD card into Aperture 3. When the battery level reached about 75%, the MacBook shut off in mid-import. I plugged the computer in and rebooted, expecting to complete the [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ngg_post_thumbnail":0,"h5ap_radio_sources":[],"footnotes":""},"categories":[66,17,8,9,7],"tags":[114,68,67,108],"class_list":["post-153","post","type-post","status-publish","format-standard","hentry","category-aperture-3","category-apple","category-computers","category-macs","category-photography","tag-aperture-3","tag-battery-life","tag-macbook-pro","tag-photography"],"_links":{"self":[{"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/posts\/153","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/comments?post=153"}],"version-history":[{"count":11,"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/posts\/153\/revisions"}],"predecessor-version":[{"id":164,"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/posts\/153\/revisions\/164"}],"wp:attachment":[{"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/media?parent=153"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/categories?post=153"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.costain.ca\/fr\/wp-json\/wp\/v2\/tags?post=153"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}