"salvaging" something from the Digikam DB
Locked
 
|
Last week, I got a message when launching Digikam, saying (more or less) that the DB was corrupt, and I could start afresh by putting the digikam.db file somewhere else.
With the new .db file, I realized I'd lost all my taggings from the preceding 10 or 12 months ; I guess that sometimes (when I upgraded Digikam?) I should have lost the settings "copy the metadata to the file".
I don't know anything about SQLite (with a MySQL DB, I would have tried to use PhpMyAdmin) ; is there anyway I can rebuild my former .db file, or try to rescue some of my old tags. I still have a backup that is a few weeks old, but I had done much tagging since then.
Thanks for helping, Marie-Noëlle -- Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe Parcourez les Cévennes à ma façon : Cévennes Plurielles Et toutes mes autres publications à partir de ma page d'accueil générale _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
No way I can try to retrieve some data from my previous digikam.db?
Thanks for any help. Marie-Noëlle 2011/5/10 Marie-Noëlle Augendre <[hidden email]> Last week, I got a message when launching Digikam, saying (more or less) that the DB was corrupt, and I could start afresh by putting the digikam.db file somewhere else. -- Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe Parcourez les Cévennes à ma façon : Cévennes Plurielles Et toutes mes autres publications à partir de ma page d'accueil générale _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: "salvaging" something from the Digikam DB
|
|
Marie-Noëlle, perhaps this way : http://ymartin59.free.fr/wordpress/index.php/2011/04/29/digikam-does-not-start-do-not-drop-your-database-yet-it-may-be-fixed/
2011/5/12 Marie-Noëlle Augendre <[hidden email]> No way I can try to retrieve some data from my previous digikam.db? -- Sylvain _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: "salvaging" something from the Digikam DB
|
|
In reply to this post by tosca
> No way I can try to retrieve some data from my previous digikam.db?
There is sqlite manager add-on for firefox: http://code.google.com/p/sqlite-manager/ And then there's http://sqlitebrowser.sourceforge.net/, I think it was available in Ubuntu repositories at least Gert _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
In reply to this post by Sylvain ZUCCA
The beginning of this article is very promising!
I'll have a look before coming back to tell you how it goes. Thanks for the link. Marie-Noëlle 2011/5/12 Sylvain ZUCCA <[hidden email]> Marie-Noëlle, perhaps this way : http://ymartin59.free.fr/wordpress/index.php/2011/04/29/digikam-does-not-start-do-not-drop-your-database-yet-it-may-be-fixed/ -- Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe Parcourez les Cévennes à ma façon : Cévennes Plurielles Et toutes mes autres publications à partir de ma page d'accueil générale _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
In reply to this post by Bugzilla from gert.kello@gmail.com
Thanks for your answer.
2011/5/12 Gert Kello <[hidden email]>
I found it this morning. Unfortunately, it seems it's unavailable for my version of Firefox (3.6.17) And then there's http://sqlitebrowser.sourceforge.net/, I think it was I'm running Fedora. But you're right, I'll see if I can find something for SQLite in Fedora repositories. Marie-Noëlle -- Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe Parcourez les Cévennes à ma façon : Cévennes Plurielles Et toutes mes autres publications à partir de ma page d'accueil générale _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: "salvaging" something from the Digikam DB
|
|
>> > No way I can try to retrieve some data from my previous digikam.db?
>> >> There is sqlite manager add-on for firefox: >> http://code.google.com/p/sqlite-manager/ > > I found it this morning. Unfortunately, it seems it's unavailable for my > version of Firefox (3.6.17) The firefox 3.6 version is available under "SQLite Manager for other applications" section, link points to http://sqlite-manager.googlecode.com/files/sqlitemanager-0.6.8-all.xpi Or You could try to use XULrunner version of the app Gert _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
Thanks for helping.
I have just installed sqliteman from the Fedora repository. It is then simply available from the Applications-Developpement GNOME menu. Just had to open (a copy of) the .db file, and update the DBVersion record as said on the page http://ymartin59.free.fr/wordpress/index.php/2011/04/29/digikam-does-not-start-do-not-drop-your-database-yet-it-may-be-fixed/ Digikam is currently in the process of reconstructing the collection, but I didn't get the "horrid" message about the database so, hopefully, it'll work fine. Marie-Noëlle
2011/5/12 Gert Kello <[hidden email]>
-- Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe Parcourez les Cévennes à ma façon : Cévennes Plurielles Et toutes mes autres publications à partir de ma page d'accueil générale _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
Re: "salvaging" something from the Digikam DB
|
|
Cool don't forget to activate the option "copy the metadata to the file" now ;)
2011/5/12 Marie-Noëlle Augendre <[hidden email]> Thanks for helping. -- Sylvain _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
|
|
Thanks for the reminder :-)
I'm pretty sure I didn't change this setting since I began to use Digikam almost 2 years ago. But, since then, I've migrated from Ubuntu to Fedora, changed machine, upgraded OS and Digikam quite a number of times ... I might have had lost it somewhere. Anyway, there might be something for the developers here: how have we (as I'm not the only one) "lost" the DBVersion number, and why isn't it possible to recover from this problem in an easier manner. Marie-Noëlle 2011/5/12 Sylvain ZUCCA <[hidden email]> Cool don't forget to activate the option "copy the metadata to the file" now ;) -- Une galerie photos, un blog ... pourquoi pas ? Webmaster en herbe Parcourez les Cévennes à ma façon : Cévennes Plurielles Et toutes mes autres publications à partir de ma page d'accueil générale _______________________________________________ Digikam-users mailing list [hidden email] https://mail.kde.org/mailman/listinfo/digikam-users |
«
Return to digikam-users
|
1 view|%1 views
| Free forum by Nabble | Edit this page |