Page tree
Skip to end of metadata
Go to start of metadata

Overview

The 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.

Warning:

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 /home directory. 
  • 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:

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite

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 user parameter:

/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user

 

Additional documentation