Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
akonadi: How to migrate from sqlite to mysql
View unanswered posts
View posts from last 24 hours
View posts from last 7 days

 
Reply to topic    Gentoo Forums Forum Index Desktop Environments
View previous topic :: View next topic  
Author Message
equaeghe
l33t
l33t


Joined: 22 Feb 2005
Posts: 632

PostPosted: Tue Apr 02, 2013 12:38 pm    Post subject: akonadi: How to migrate from sqlite to mysql Reply with quote

Hi,


With the recent KDE 4.10.1 stabilization, one of the messages I got was to migrate from sqlite to mysql. How do I do this for exisiting users?
Do I just need to replace the driver by QMYSQL in the akonadirc file? Is the database automatically migrated then?


TIA,

Erik
Back to top
View user's profile Send private message
albright
Advocate
Advocate


Joined: 16 Nov 2003
Posts: 2588
Location: Near Toronto

PostPosted: Tue Apr 02, 2013 3:08 pm    Post subject: Reply with quote

Quote:
Do I just need to replace the driver by QMYSQL in the akonadirc file?


That worked for me; just commented out QSQLITE3 line and added

Code:
Driver=QMYSQL


in ~/.config/akonadi/akonadiserverrc and restarted; everything
appears to be the same as before
_________________
.... there is nothing - absolutely nothing - half so much worth
doing as simply messing about with Linux ...
(apologies to Kenneth Graeme)
Back to top
View user's profile Send private message
dilfridge
Developer
Developer


Joined: 18 Sep 2010
Posts: 120
Location: Regensburg, Germany

PostPosted: Tue Apr 02, 2013 11:00 pm    Post subject: Reply with quote

Editing the config file works fine, just as described above.

Alternatively, you can open the Akonadi settings application from the system tray, and do it there. That's also doing the job.

In either case your database is NOT migrated, because unfortunately that is not possible. That does not matter too much, you are not really losing anything because Akonadi is just a cache. If you are using the IMAP offline mode, you will have to re-download your e-mails from the server though (to have a local offline copy again).
Back to top
View user's profile Send private message
leifbk
Guru
Guru


Joined: 05 Jan 2004
Posts: 415
Location: Bærum, Norway

PostPosted: Fri Apr 19, 2013 2:09 pm    Post subject: Reply with quote

Starting mysql would also be a good idea, as I discovered :oops:
_________________
Grumpy old man
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Desktop Environments All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum