How do I convert Roundcube from MySQL to SQLite?

Question

How do I convert Roundcube from MySQL to SQLite?

Answer

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.

1. Log in to the server via SSH or WHM's Terminal as the root user

2. Convert the Roundcube database in cPanel & WHM from MySQL to SQLite by running the following command:

   # /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

   Note: 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.