Author Topic: migrate db script sqlite -> mysql  (Read 96 times)

Offline tessus

  • Newbie
  • *
  • Posts: 1
migrate db script sqlite -> mysql
« on: November 10, 2019, 05:06:23 PM »
Hello,

I've been using Roundcube for years now and I think it is time to move from sqlite to mysql. However, there's no documentation on how to do that, nor are there any scripts available.

It would be great, if there was a script that takes care of all that. Or even a document would be enough.

Of course I could manually export tables from sqlite and import them into mysql. Is this going to be enough? Do I have to take care of any other things (except changing the config file). I could only find the wiki page which references the defaults.inc.php. It's very well documented (great job), but some info is still missing. e.g. when using apc can I use APCu, or do I have to use the old apc extension?

I would also like to get some info on: when is sqlite no longer appropriate? A comparison of caching backends. e.g. mostly the php igbinary serializer is faster than redis. But maybe there are other reasons why someone would pick redis. Basically a best practices document would be a great addition.

Cheers,
  K. C.


P.S.: What's up with the captcha stuff? I'm a registered user, yet I have to enter a captcha every time?