{"id":462,"date":"2021-07-23T12:30:24","date_gmt":"2021-07-23T12:30:24","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/how-to-rebuild-the-roundcube-database\/"},"modified":"2021-07-23T12:30:24","modified_gmt":"2021-07-23T12:30:24","slug":"how-to-rebuild-the-roundcube-database","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/how-to-rebuild-the-roundcube-database\/","title":{"rendered":"How to Rebuild the Roundcube Database"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

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.<\/p>\n

\n
Warning:<\/div>\n
\n cPanel, L.L.C. deprecated the update-roundcube<\/code> and update-roundcube-sqlite<\/code> scripts in cPanel & WHM version 62.\n <\/div>\n<\/div>\n

Path and filename for the database<\/h2>\n

The SQLite database uses the following path and filename, where username<\/code> represents a cPanel account username and domain<\/code> represents a domain name: <\/p>\n

\n
\/home\/<\/span>username\/etc\/<\/span>domain\/<\/span>username.<\/span>rcube.<\/span>db<\/code><\/pre>\n<\/div>\n
Additionally, the database applies the following naming conventions, where username<\/code> represents a cPanel account username:<\/p>\n\n\n\n\n\n\n\n
Name<\/th>\nDescription<\/th>\nExample<\/th>\n<\/tr>\n<\/thead>\n
\/home\/username\/etc\/domain\/username.rcube.db.1495814375<\/code><\/td>\nA backup file with a Unix timestamp.<\/td>\nusername.rcube.db.1495814375<\/code><\/td>\n<\/tr>\n
\/home\/username\/etc\/domain\/username.rcube.db.latest<\/code><\/td>\nA symlink to the latest Roundcube backup.<\/td>\nusername.rcube.db.latest<\/code><\/td>\n<\/tr>\n
\/home\/username\/etc\/domain\/username.rcube.db.datestamp.sqlite2<\/code><\/td>\nAn SQLite v2 backup file.<\/td>\nusername.rcube.db.20170523105040.sqlite2<\/code><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
Rebuild a Roundcube database<\/h2>\n
To update a Roundcube database, run one of the following commands:\n<\/p>\n
\n
\n\n\n
\n
1\n<\/span>2\n<\/span><\/code><\/pre>\n<\/td>\n
\n
\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>cpanel<\/span>\/<\/span>bin<\/span>\/<\/span>update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span> --<\/span>force<\/span>\n\/<\/span>usr<\/span>\/<\/span>local<\/span>\/<\/span>cpanel<\/span>\/<\/span>bin<\/span>\/<\/span>update<\/span>-<\/span>roundcube<\/span>-<\/span>sqlite<\/span>-<\/span>db<\/span> --<\/span>force<\/span><\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n
\n
Note:<\/div>\n
\n        The \/usr\/local\/cpanel\/bin\/update-roundcube-db<\/code> script will update your database whether you use MySQL\u00ae or SQLite. The script recognizes whether you use SQLite and automatically runs the \/usr\/local\/cpanel\/bin\/update-roundcube-sqlite-db<\/code> script.\n    <\/div>\n<\/div>\n
MySQL database<\/h3>\n
Use the \/usr\/local\/cpanel\/bin\/update-roundcube-db<\/code> script to rebuild a Roundcube MySQL database.<\/p>\n
To rebuild a Roundcube database, run the following command:<\/p>\n
\n
\/usr\/<\/span>local\/cpanel\/<\/span>bin\/<\/span>update-<\/span>roundcube-<\/span>db --<\/span>force<\/code><\/pre>\n<\/div>\n
If the script succeeds, you will receive a message that resembles the following example:\n<\/p>\n
\n
\n\n\n
\n
1\n<\/span>2\n<\/span>3\n<\/span>4\n<\/span>5\n<\/span>6\n<\/span>7\n<\/span>8\n<\/span><\/code><\/pre>\n<\/td>\n
\n
info<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> update<\/span> from<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span> to<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span> in<\/span> progress<\/span>.\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> will<\/span> be<\/span> locked<\/span> out<\/span> during<\/span> this<\/span> process<\/span>.\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Archiving<\/span> current<\/span> Roundcube<\/span> data<\/span> to<\/span> \/<\/span>var<\/span>\/<\/span>cpanel<\/span>\/<\/span>roundcube<\/span>\/<\/span>roundcube<\/span>.backup<\/span>.sql<\/span>.1479139688<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> DB<\/span> successfully<\/span> archived<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Cleaning<\/span> old<\/span> Roundcube<\/span> data<\/span> archives<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Removing<\/span> old<\/span> backup<\/span>: roundcube<\/span>.backup<\/span>.sql<\/span>.1467293128<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Schema<\/span> update<\/span> to<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span> was<\/span> successful<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> updated<\/span> to<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span><\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n
SQLite database<\/h3>\n
Use the \/usr\/local\/cpanel\/bin\/update-roundcube-sqlite-db<\/code> script to rebuild a Roundcube SQLite database.<\/p>\n
To rebuild a Roundcube database, run the following command:<\/p>\n
\n
\/usr\/<\/span>local\/cpanel\/<\/span>bin\/<\/span>update-<\/span>roundcube-<\/span>sqlite-<\/span>db --<\/span>force<\/code><\/pre>\n<\/div>\n
If the script succeeds, you will receive a message that resembles following example:\n<\/p>\n
\n
\n\n\n
\n
1\n<\/span>2\n<\/span>3\n<\/span>4\n<\/span>5\n<\/span>6\n<\/span>7\n<\/span>8\n<\/span><\/code><\/pre>\n<\/td>\n
\n
info<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> update<\/span> from<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span> to<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span> in<\/span> progress<\/span>.\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> will<\/span> be<\/span> locked<\/span> out<\/span> during<\/span> this<\/span> process<\/span>.\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Archiving<\/span> current<\/span> Roundcube<\/span> data<\/span> to<\/span> \/<\/span>var<\/span>\/<\/span>cpanel<\/span>\/<\/span>roundcube<\/span>\/<\/span>roundcube<\/span>.backup<\/span>.sql<\/span>.1479139822<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> DB<\/span> successfully<\/span> archived<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Cleaning<\/span> old<\/span> Roundcube<\/span> data<\/span> archives<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Removing<\/span> old<\/span> backup<\/span>: roundcube<\/span>.backup<\/span>.sql<\/span>.1469194482<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Schema<\/span> update<\/span> to<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span> was<\/span> successful<\/span>\ninfo<\/span> [update<\/span>-<\/span>roundcube<\/span>-<\/span>db<\/span>] Roundcube<\/span> updated<\/span> to<\/span> 1.1.4<\/span>-<\/span>7.<\/span>cp1162<\/span><\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
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. Warning: cPanel, L.L.C. deprecated the update-roundcube and update-roundcube-sqlite scripts in cPanel & WHM version 62. Path and filename …<\/p>\n","protected":false},"author":1,"featured_media":463,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/462"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=462"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/462\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/463"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}