Introduction
For a more stable, portable, and faster experience with Roundcube, user databases should be converted to SQLite from MySQL.
Warning:
If you change Roundcube’s database to an SQLite database, you cannot revert back to a MySQL database.
Procedure
To convert the Roundcube database in cPanel & WHM from MySQL to SQLite, run the following command:
/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite
After you convert the system to an SQLite database, you can use this script to troubleshoot issues with specific users.
When troubleshooting a failed conversion, to convert the Roundcube data for a single cPanel user from MySQL to SQLite, run the same command with the user parameter, where user represents the database user:
/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user
Note, all users on a system must use the same database format. You cannot use this script to convert just one user and leave the rest using MySQL.