sqlite to mysql when using transfer tool
I am about to migrate using different whmconf version and is seeing the below error.
|
CPANEL AND WHM:
Local WHMConf: 11.122.0.15
Remote WHMConf: 11.110.0.39 DATABASE SERVER:
Local Type: MariaDB
Local Version: 10.11 Remote Type: MariaDB Remote Version: 10.5 |
Source: “source-server-fqdn” Roundcube database type is “mysql” …
Target: “destination-server-fqdn” Roundcube database type is “sqlite” …
The source server is not running the same Roundcube database type as the target server. cPanel highly recommends that the source server run the same Roundcube database type at least 24 hours to ensure that email accounts using Roundcube will transfer properly.
Do we have option not to convert from mysql to sqlite when migrating emails?
Any particular reason with enforcing sqlite or is this expected on newer versions?
Appreciate any inputs here.
-
Hey there! Modern cPanel servers are using sqlite for Roundcube - this way, if something happens to the MySQL structure on the system, emails aren't affected.
I would recommend running the conversion before performing the migration as outlined in the warning.
0 -
I'll be a bit strong than cPRex and highly, highly recommend that you do this (and save yourself a ton of grief). Converting is very easy (https://docs.cpanel.net/knowledge-base/webmail/how-to-convert-roundcube-to-sqlite/) just give yourself time. This conversion process appears to loop over every mailbox in every account, so it an crunch for a bit.
If you don't do this before the migration and any of your accounts have contacts saved in RoundCube you'll loose them during the conversion. You can get them back by logging into the old server/webmail and export each mailboxes list, then log into the new server webmail for each mailbox and import them.
It's just a lot easier to do before.
0 -
The thing is it is running on cPanel version 110 as the Source Server, and on a CloudLinux 7 as we speak, will we encounter issue in the conversion process? I am leaning into the option of back-up restore but the destination server is running on Ubuntu. I saw somewhere that there were issues converting from mysql to sqlite and also saw that cPanel cannot be upgraded to version 112 since it is still in CloudLinux7, is it a good idea doing the back-up restore option? Thanks! Really appreciate your inputs here.
0 -
The conversion process will work fine regardless of the cPanel version, so I wouldn't hesitate to run that.
0
Please sign in to leave a comment.
Comments
4 comments