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.
Benefits of Roundcube with SQLite databases
The SQLite database provides the following benefits over MySQL:
- You can restore Roundcube data more easily. The system stores each email user's Roundcube data in a separate SQLite database file. This allows you to restore data for a single user and not impact the whole server.
- You can track disk usage properly because the system stores the Roundcube data within a cPanel user's
- You can locate problematic accounts more easily because the Roundcube PHP processes run as the cPanel user.
- There is no single point of failure. Because each user's SQLite database is separate, database corruptions only impact a single user and not the entire system.
Convert Roundcube to SQLite
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