Kubuntu

Akonadi, Sqlite and Backups Part 2

Dec 1, 2014
Linux, Kubuntu, Akonadi, Sqlite, Backups

There are various ways you can backup sqlite. One of the ways is to use the sqlite3 command line utility: /usr/bin/sqlite3 ~/.local/share/akonadi/akonadi.db SQLite version 3.8.6 2014-08-15 11:46:33 Enter ".help" for usage hints. sqlite> .backup /tmp/akonadi.db sqlite> .quit This will create a backup of akonadi.db in /tmp. Sqlite also comes with a backup API - see https://www.sqlite.org/backup.html. As python tends to be my scripting language of choice I was looking for something that I could use in python. ...

Akonadi, Sqlite and Backups Part 1

Dec 1, 2014
Linux, Kubuntu, Akonadi, Sqlite, Backups

On both my home PC and work laptop I use kontact for my email, calendaring, etc. I didn’t want to use mysql for the underlying database (I don’t particular like it) so decided to use sqlite instead. Generally I have found this to work well, with one or two exceptions. However, searching for how to automate sqlite backups gives numerous results. The easiest way is to stop whatever is writing to it, in this case akonadi, and then copy the database. ...

No Icons or Emoticons in Firefox or Pidgin

Nov 8, 2014
Linux, Kubuntu, Firefox, Pidgin

The other day I upgraded my laptop from Kubuntu 14.04 to 14.10 and after it had completed I found that I had no icons or emoticons in all my GTK applications - including Firefox and Pidgin. Eventually tracked it down to the fact that a particular cache wasn’t available. To fix it you need to run the following command: gdk-pixbuf-query-loaders > /usr/lib/x86_64-linux-gnu/gdk-pixbuf-2.0/2.10.0/loaders.cache If gdk-pixbuf-query-loaders in not installed you need to install the following package: ...