How do I convert Roundcube from MySQL to SQLite?

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.