Overview
If your Roundcube database fails to restart or becomes corrupt, you can rebuild the Roundcube database to repair it. This document explains how to rebuild a Roundcube database in cPanel & WHM version 60 and earlier.
update-roundcube and update-roundcube-sqlite scripts in cPanel & WHM version 62.
Path and filename for the database
The SQLite database uses the following path and filename, where username represents a cPanel account username and domain represents a domain name:
/home/username/etc/domain/username.rcube.dbAdditionally, the database applies the following naming conventions, where username represents a cPanel account username:
| Name | Description | Example |
|---|---|---|
/home/username/etc/domain/username.rcube.db.1495814375 |
A backup file with a Unix timestamp. | username.rcube.db.1495814375 |
/home/username/etc/domain/username.rcube.db.latest |
A symlink to the latest Roundcube backup. | username.rcube.db.latest |
/home/username/etc/domain/username.rcube.db.datestamp.sqlite2 |
An SQLite v2 backup file. | username.rcube.db.20170523105040.sqlite2 |
Rebuild a Roundcube database
To update a Roundcube database, run one of the following commands:
|
|
/usr/local/cpanel/bin/update-roundcube-db script will update your database whether you use MySQL® or SQLite. The script recognizes whether you use SQLite and automatically runs the /usr/local/cpanel/bin/update-roundcube-sqlite-db script.
MySQL database
Use the /usr/local/cpanel/bin/update-roundcube-db script to rebuild a Roundcube MySQL database.
To rebuild a Roundcube database, run the following command:
/usr/local/cpanel/bin/update-roundcube-db --forceIf the script succeeds, you will receive a message that resembles the following example:
|
|
SQLite database
Use the /usr/local/cpanel/bin/update-roundcube-sqlite-db script to rebuild a Roundcube SQLite database.
To rebuild a Roundcube database, run the following command:
/usr/local/cpanel/bin/update-roundcube-sqlite-db --forceIf the script succeeds, you will receive a message that resembles following example:
|
|
