Translate

Translate to руски

Translation of the wiki page Digikam/Check Database from English (en).

This tool does not work without JavaScript. JavaScript is disabled, failed to work, or this browser is unsupported.

Translations:Digikam/Check Database/Page display title/rsk

Digikam/Check Database

You need translation rights to translate messages.Get permission

Loading...

== Check and Optimize digiKam’s Databases == Transcribed from Dmitri Popov's blog, 19 December 2011‎

Edit

By default, '''digiKam''' uses two ''SQLite databases'' for storing essential data: ''digikam4.db'' and ''thumbnails-digikam.db''. And to make the application run fast and smoothly, it’s a good idea to check and optimize the databases every now and then. To do this on Ubuntu or its derivatives, you need to install the <tt>sqlite3</tt> package using the <code>sudo apt-get install sqlite3</code> command. Once you’ve done that, back up the digikam4.db and thumbnails-digikam.db databases. Open then the terminal and switch to the directory where the databases are stored. First off, you should check the integrity of both databases using the following commands:‎

Edit

{{Input|1=sqlite3 -line digikam4.db 'pragma integrity_check;' sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'}}‎

Edit

If both databases are in order, you should see the message {{Output|1=integrity_check = ok}}‎

Edit

To optimize the databases, run the two commands below:‎

Edit

{{Input|1-sqlite3 -line digikam4.db 'vacuum;' sqlite3 -line thumbnails-digikam.db 'vacuum;'}}‎

Edit

Run then the integrity check once again to make sure that everything works properly, and you are done.‎

Edit

[[Category:Graphics]] [[Category:Photography]] [[Category:Tutorials]]‎

Edit