[Digikam-users] Some questions about digikam4.db

[Gilles Caulier]

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/1ca25338/attachment.html>