{"id":685,"date":"2021-07-23T12:35:37","date_gmt":"2021-07-23T12:35:37","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/how-to-convert-roundcube-to-sqlite\/"},"modified":"2021-07-23T12:35:37","modified_gmt":"2021-07-23T12:35:37","slug":"how-to-convert-roundcube-to-sqlite","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/how-to-convert-roundcube-to-sqlite\/","title":{"rendered":"How to Convert Roundcube to SQLite"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

The \/usr\/local\/cpanel\/scripts\/convert_roundcube_mysql2sqlite<\/code> script updates the Roundcube configuration to use individual SQLite databases instead of a single MySQL\u00ae database. This document explains how to use that script.<\/p>\n

\n
Warning:<\/div>\n
\n If you change Roundcube\u2019s database to a SQLite database, you cannot<\/strong> revert back to a MySQL database.\n <\/div>\n<\/div>\n

The SQLite database provides the following benefits over a MySQL database:<\/p>\n

    \n
  • You can restore Roundcube data more easily. The system stores each email user\u2019s Roundcube data in a separate SQLite database. This behavior allows you to restore data for a single user and not the entire system.<\/li>\n
  • You can track disk usage properly because the system stores the Roundcube data within a cPanel user\u2019s \/home<\/code> directory.<\/li>\n
  • You can locate problematic accounts more easily because the Roundcube PHP processes run as the cPanel user.<\/li>\n
  • A single point of failure does not exist, and database corruptions only impact a single user, not the entire system.<\/li>\n<\/ul>\n

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

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

    \n
    \/home\/<\/span>username\/etc\/<\/span>domain\/<\/span>username.<\/span>rcube.<\/span>db<\/code><\/pre>\n<\/div>\n
    Convert Roundcube to SQLite database<\/h2>\n
    To convert the Roundcube database in cPanel & WHM from MySQL to SQLite, run the following command: <\/p>\n
    \n
    \/usr\/<\/span>local\/cpanel\/sc<\/span>ripts\/<\/span>convert_roundcube_mysql2sqlite<\/code><\/pre>\n<\/div>\n
    After you convert the system to a SQLite database, you can use this script to troubleshoot issues with specific users.<\/p>\n
    To convert the Roundcube data for a single cPanel user from MySQL to SQLite, run the same command with the user<\/code> parameter, where user<\/code> represents the database user: <\/p>\n
    \n
    \/usr\/<\/span>local\/cpanel\/sc<\/span>ripts\/<\/span>convert_roundcube_mysql2sqlite user<\/code><\/pre>\n<\/div>\n
    Migrate a Roundcube MySQL database to a SQLite database<\/h2>\n
    To migrate a Roundcube database from one cPanel & WHM server to another and convert the data from a MySQL database to a SQLite database, perform the following steps:<\/p>\n
      \n
    1. \n
      On the source cPanel & WHM server, create a backup of the Roundcube database. To do this, run the following command, where roundcube<\/code> represents the Roundcube database: <\/p>\n
      \n
      mysqldump roundcube ><\/span> roundcube.<\/span>dump<\/code><\/pre>\n<\/div>\n<\/li>\n
    2. \n
      On the destination cPanel & WHM server, create a temporary MySQL database. To do this, follow the directions in our MySQL Databases<\/em> documentation.<\/p>\n<\/li>\n
    3. \n
      On the destination cPanel & WHM server, open the \/usr\/local\/cpanel\/scripts\/convert_roundcube_mysql2sqlite<\/code> script and convert the following code snippet to a comment:<\/p>\n
      \n
      \n\n\n
      \n
      1\n<\/span>2\n<\/span>3\n<\/span>4\n<\/span>5\n<\/span><\/code><\/pre>\n<\/td>\n
      		\n
      --<\/span>>\n                unless<\/span> ( defined<\/span> $<\/span>opt_dbname<\/span> ) {\n                    Cpanel<\/span>::Email<\/span>::RoundCube<\/span>::archive_and_drop_mysql_roundcube<\/span>( $<\/span>has_db<\/span>, $<\/span>logger<\/span> );\n                }\n<--<\/span><\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n<\/li>\n
    4. \n
      On the destination cPanel & WHM server, import the Roundcube data to the database and convert the data to SQLite. Run the following command on the destination cPanel & WHM server, where user<\/code> represents the database user and exampledatabase<\/code> represents the database for which to import the Roundcube data:<\/p>\n
      \n
      \/usr\/<\/span>local\/cpanel\/sc<\/span>ripts\/<\/span>convert_roundcube_mysql2sqlite user exampledatabase<\/code><\/pre>\n<\/div>\n<\/li>\n
    5. \n
      The server will attempt to convert the Roundcube mailbox. If it encounters any errors, it will repeat the process until the conversion is successful.<\/p>\n<\/li>\n<\/ol><\/div>\n","protected":false},"excerpt":{"rendered":"
      Overview The \/usr\/local\/cpanel\/scripts\/convert_roundcube_mysql2sqlite script updates the Roundcube configuration to use individual SQLite databases instead of a single MySQL\u00ae database. This document explains how to use that script. Warning: If you change Roundcube\u2019s database to a SQLite database, you cannot revert back to a MySQL database. The SQLite database provides the following benefits over a MySQL …<\/p>\n","protected":false},"author":1,"featured_media":686,"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\/685"}],"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=685"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/685\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/686"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}