Hi list,
I had to do this job anyway, so why not share with all.
To check your database´s integrety you need to install the command line
utillity ¨sqlite3¨ first if it is not already done.
¨sudo apt-get install sqlite3¨ worked perfectly well for me.
Make copies of your digikam4.db and and thumbnails-digikam.db
Go in console to the directory containing your db
copy and drop this entire line beneath inclusive the single quote sign:
sqlite3 -line digikam4.db 'pragma integrity_check;'
and hopefully you get the result:
integrity_check = ok
If you want to speedup/cleanup
Close any running digiKam program
go in to your digiKam base directory and backup your digikam4.db file.
From command line run the following :
sqlite3 -line digikam4.db 'vacuum;'
and if done
sqlite3 -line thumbnail-digikam.db 'vacuum;'
In the meanwhile you can have a cup of coffee, or two, or maybe three.
And finaly do an integrety check on both db´s
If they are ok everything should run smooth now.
I just did it myself to make sure that everything is as should.
My digikam4.db went to half of it´s size and thumbnails-digikam.db
remained as before.
digiKam became much more responsive.
All credits go to Jean-François Rabasse, who teached me in this matter.
Good luck,
Rinus
_______________________________________________
Digikam-users mailing list
[hidden email]
https://mail.kde.org/mailman/listinfo/digikam-users
Locked
