[Digikam-users] Some questions about digikam4.db

[Gilles Caulier]

oups, not sqlitemanager, but sqlitebrowser (:=))):

http://sqlitebrowser.sourceforge.net/

Gilles

2011/11/9 Gilles Caulier <caulier.gilles at gmail.com>

> Make a backup and drop table using sqlite manager.
>
> http://www.sqlitemanager.org/
>
> If it work, perhaps somebody can write a script to automatize this task
>
> Gilles
>
>
> 2011/11/9 Anders Stedtlund <falolaf at gmail.com>
>
>> Hi,
>>
>> I have just tested anyway. (Have backup of course...)
>>
>> Deleted Thumbnails and compacted. Now the size of digikam4.db is
>> ~20MB. digiKam starts and everything seems to be working...
>>
>> I can see that there is actually 4 tables that have been removed:
>> CustomIdentifiers
>> FilePaths
>> Thumbnails
>> UniqueHashes
>>
>> How about removing them all from the old db? What might happen?
>>
>> /Anders
>>
>> 2011/11/9 Gilles Caulier <caulier.gilles at gmail.com>:
>> >
>> >
>> > 2011/11/9 Anders Stedtlund <falolaf at gmail.com>
>> >>
>> >> Hi,
>> >>
>> >> I have now tested 2.3.0 with a new fresh profile. In this version the
>> >> Thumbnails table doesn't exits anymore.
>> >>
>> >> Would it be safe to just drop the Thumbnails table in the old db file?
>> >
>> > I think yes, but the right response must come from Marcel or Francesco,
>> to
>> > be sure.
>> > Gilles Caulier
>> > _______________________________________________
>> > Digikam-users mailing list
>> > Digikam-users at kde.org
>> > https://mail.kde.org/mailman/listinfo/digikam-users
>> >
>> >
>> _______________________________________________
>> Digikam-users mailing list
>> Digikam-users at kde.org
>> https://mail.kde.org/mailman/listinfo/digikam-users
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/digikam-users/attachments/20111109/821dc89b/attachment.html>