convert_roundcube_mysql2sqlite script updates the Roundcube configuration to use individual SQLite databases instead of a single MySQL® database. This document explains how to use that script.
If you change Roundcube's database engine to SQLite, you cannot change it back to MySQL.
The SQLite database provides the following benefits over MySQL:
To convert the Roundcube database in cPanel & WHM from MySQL to SQLite, run the following command:
After you convert the system to SQLite, you can use this script to troubleshoot issues with specific users.
To convert the Roundcube data for a single cPanel user from MySQL to SQLite, run the same command with the
To migrate a Roundcube database from one cPanel & WHM server to another and convert the data from MySQL to SQLite, perform the following steps:
On the source cPanel & WHM server, create a backup of the Roundcube database. To do this, run the following command:
In this example,
rcubedb represents the Roundcube database.
On the destination cPanel & WHM server, create a temporary MySQL database. To do this, follow the directions in our MySQL Databases documentation.
On the destination cPanel & WHM server, open the
/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite script and comment out the following lines:
On the destination cPanel & WHM server, import the Roundcube data to the database and convert the data to SQLite. To do this, run the following command on the destination cPanel & WHM server:
The above command contains the following example arguments:
userrepresents the database user.
litedbfromsqlrepresents the database to which to import the Roundcube data.