Filesystem lost images - can digiKam report which ones?

[Kyle Altendorf]

Hi All,

I messed up and let Linux boot with Windows in hibernate...  well, I
don't know 100% that's why but it's my best suspect.  The symptom is
missing images.  What I am curious about is if digiKam can tell me
which ones it expects to find but are not actually there any more.

Any help would be appreciated.

Cheers,
-kyle
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Ben Staude]

Hi kyle,

did you start DigiKam since you lost the images? If yes, do you have a recent
backup of its database? One possible route to go would be some perl (or the
like) script to "loop through all "Images" entries in digikams database and
check if the file exists in the filesystem".
If you already did start digikam, the image data (name, file size etc) should
still be there, but the paths might be lost. And you might not be able to
decide whether a file is lost or has been deleted intentionally some day in
the past.

Ben

Am Freitag 31 August 2012 schrieb Kyle Altendorf:

> Hi All,
>
> I messed up and let Linux boot with Windows in hibernate...  well, I
> don't know 100% that's why but it's my best suspect.  The symptom is
> missing images.  What I am curious about is if digiKam can tell me
> which ones it expects to find but are not actually there any more.
>
> Any help would be appreciated.
>
> Cheers,
> -kyle
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Kyle Altendorf]

On Sun, Sep 2, 2012 at 8:36 AM, Ben Staude <[hidden email]> wrote:
> Hi kyle,
>
> did you start DigiKam since you lost the images? If yes, do you have a recent
> backup of its database?

Backup?  Hah!  You're funny.  :]  Though the fact that I haven't been
backing up for quite awhile is not so particularly funny.  :[

> One possible route to go would be some perl (or the
> like) script to "loop through all "Images" entries in digikams database and
> check if the file exists in the filesystem".

I was hoping digiKam had such a feature built-in.  I feel like I
remember it from a few years back, but that's probably just wishful
thinking.  If I do write such a script I'll be sure to share it here.

> If you already did start digikam, the image data (name, file size etc) should
> still be there, but the paths might be lost. And you might not be able to
> decide whether a file is lost or has been deleted intentionally some day in
> the past.

For the most part I mark with one star rather than deleting, so that
could make this a touch easier.

Thanks for the reply and suggestions.

Cheers,
-kyle

>
> Ben
>
> Am Freitag 31 August 2012 schrieb Kyle Altendorf:
>> Hi All,
>>
>> I messed up and let Linux boot with Windows in hibernate...  well, I
>> don't know 100% that's why but it's my best suspect.  The symptom is
>> missing images.  What I am curious about is if digiKam can tell me
>> which ones it expects to find but are not actually there any more.
>>
>> Any help would be appreciated.
>>
>> Cheers,
>> -kyle
>> _______________________________________________
>> Digikam-users mailing list
>> [hidden email]
>> https://mail.kde.org/mailman/listinfo/digikam-users
>
> _______________________________________________
> Digikam-users mailing list
> [hidden email]
> https://mail.kde.org/mailman/listinfo/digikam-users

_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users

[Ben Staude]

> > On Sun, Sep 2, 2012 at 8:36 AM, Ben Staude <[hidden email]> wrote:
> > Hi kyle,
> >
> > did you start DigiKam since you lost the images? If yes, do you have a recent
> > backup of its database?
>
> Backup?  Hah!  You're funny.  :]  Though the fact that I haven't been
> backing up for quite awhile is not so particularly funny.  :[

Well, this might (should?) be the point to think again over whether a backup is worth the effort or not:) I use storeBackup and am really happy with it.

> > One possible route to go would be some perl (or the
> > like) script to "loop through all "Images" entries in digikams database and
> > check if the file exists in the filesystem".
>
> I was hoping digiKam had such a feature built-in.  I feel like I
> remember it from a few years back, but that's probably just wishful
> thinking.  If I do write such a script I'll be sure to share it here.

Here is some "script" you could start with (use on your own risk, probably deletes all remaining images:) ):

perl -e '@filesystem=split /\n/, `find /path/to/foto-collection -type f`; foreach $name (split /\n/, `sqlite3 /path/to/digikam4.db "select Name from Images;"`) { print "missing: $name\n" unless grep { /\/\Q$name\E$/ } @filesystem }'

This is a simple approach, but might yield some helpful results if you didn't rename or delete a lot of files in the past.

Regards
Ben
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users