Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Import DirectAdmin RoundCube database

Discussion in 'Migrate to cPanel' started by razrdj, Oct 4, 2017.

  1. razrdj

    razrdj Active Member

    Joined:
    Oct 1, 2013
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    I switched a server from DirectAdmin to cPanel today, I would like to import an existing RoundCube database. A year ago I succeeded by exporting the RC database, removing the cPanel version and importing it. All contacts, settings, identities were there.

    New installations come with SQLite 3, how can I import the database now?

    I tried the command (yes I changed the user and litedbfromsql with my own user and db)
    Code:
    /usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user litedbfromsql
    It returns null and I don't have my contacts and identities back.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    There's no support for importing a Roundcube database from a DirectAdmin server into a cPanel server. Have you considered using the import and export options available in Roundcube to move the contacts over to the cPanel server?

    Thank you.
     
  3. razrdj

    razrdj Active Member

    Joined:
    Oct 1, 2013
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Hi Michael,

    That would be a lot of work to do it for every e-mailaccount. Is there something else available to import export every user contacts and identities?

    Thanks!
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Can you verify the method you used to copy the account to the cPanel server? Did you use "WHM >> Transfer Tool"?

    Thank you.
     
  5. razrdj

    razrdj Active Member

    Joined:
    Oct 1, 2013
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Correct. But the RoundCube contacts and identities were not copied, some customers use RoundCube and woud like to have their signature and contacts back. The way is to export from the old server and import back, but I want to do it globally for all users. With the previous cPanel (before SQLite 3) I was able to just copy the RoundCube database to the cPanel server.
     
  6. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,427
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    The following document offers some manual MySQL to SQLite conversion instructions for Roundcube that you could try:

    How to Convert Roundcube to SQLite - cPanel Knowledge Base - cPanel Documentation

    However, this is unsupported and not tested from remote control panels. I'm not aware of any workarounds that would allow you to transfer the Roundcube MySQL data from a DirectAdmin server directly to cPanel as Roundcube SQLite data. The best approach would be to manually export and import the contacts directly through the Roundcube interface on an account-by-account basis.

    Thank you.
     
  7. razrdj

    razrdj Active Member

    Joined:
    Oct 1, 2013
    Messages:
    26
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Okay, I will use the export import functionality from RoundCube itself.

    Thanks Michael :)
     
Loading...

Share This Page