Digikam/Check Database/de: Difference between revisions
(Created page with "== Überprüfen und optimieren der digiKam Datenbank == Transcribed from Dmitri Popov's blog, 19 December 2011") |
(Updating to match new version of source page) |
||
| (8 intermediate revisions by 2 users not shown) | |||
| Line 4: | Line 4: | ||
Transcribed from Dmitri Popov's blog, 19 December 2011 | Transcribed from Dmitri Popov's blog, 19 December 2011 | ||
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: | 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: | ||
{{Input|1=sqlite3 -line digikam4.db 'pragma integrity_check;' | {{Input|1=sqlite3 -line digikam4.db 'pragma integrity_check;' | ||
sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'}} | sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'}} | ||
Wenn beide Datenbanken in Ordnung sind, sollte diese Meldung erscheinen: {{Output|1=integrity_check = ok}} | |||
Um die Datenbanken zu optimieren, nutzt man die beiden folgenden Befehle: | |||
{{Input|1-sqlite3 -line digikam4.db 'vacuum;' | {{Input|1-sqlite3 -line digikam4.db 'vacuum;' | ||
sqlite3 -line thumbnails-digikam.db 'vacuum;'}} | sqlite3 -line thumbnails-digikam.db 'vacuum;'}} | ||
Lassen Sie die Integritäts-Überprüfung erneut laufen, um sicher zu gehen, dass alles fehlerfrei arbeitet; damit ist der Vorgang abgeschlossen. | |||
[[Category: | [[Category:Grafik/de]] | ||
[[Category: | [[Category:Fotografie/de]] | ||
[[Category: | [[Category:Anleitungen/de]] | ||
Latest revision as of 13:00, 4 July 2019
Überprüfen und optimieren der digiKam Datenbank
Transcribed from Dmitri Popov's blog, 19 December 2011
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 sqlite3 package using the sudo apt-get install sqlite3 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:
sqlite3 -line digikam4.db 'pragma integrity_check;' sqlite3 -line thumbnails-digikam.db 'pragma integrity_check;'
Wenn beide Datenbanken in Ordnung sind, sollte diese Meldung erscheinen:
integrity_check = ok
Um die Datenbanken zu optimieren, nutzt man die beiden folgenden Befehle:
1-sqlite3 -line digikam4.db 'vacuum;' sqlite3 -line thumbnails-digikam.db 'vacuum;'
Lassen Sie die Integritäts-Überprüfung erneut laufen, um sicher zu gehen, dass alles fehlerfrei arbeitet; damit ist der Vorgang abgeschlossen.