For some reason I need to do a distribution wide Akonadi database backend switch. Currently it uses my mysql for the database and I want it to use sqlite.
This needs to happen automatically for every user that installs the new package ( a script will run ).
I've made the script change akonadiserverrc for every user but there's still one more problem. How do I migrate the data from the mysql database to the sqlite database ?

You will need to consult the 3rd party MySQL and SQLite documentation for this. I guess dumping the data from the MySQL databases then importing it into a SQLite database should do the trick.

Well I've found some things for doing this but I thought there was something implemented in Akonadi. There's all kinds of scripts and stuff but I'm not sure if they will work.
Will have to test I guess.
Any ideas on how to populate the Akondi database ? Adding some contacts in KAddressBook ?

bcooksley wrote:You will need to consult the 3rd party MySQL and SQLite documentation for this. I guess dumping the data from the MySQL databases then importing it into a SQLite database should do the trick.

Adding contacts should be done by adding entries to the appropriate resources Akonadi interfaces with. It should have a contacts resource, which will store data somewhere on the system, probably under ~/.local/

bcooksley wrote:Adding contacts should be done by adding entries to the appropriate resources Akonadi interfaces with. It should have a contacts resource, which will store data somewhere on the system, probably under ~/.local/

OK, I'll give it a try.

Thank you.