Import DirectAdmin RoundCube database

razrdj

• October 04, 2017 17:02

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)
/usr/local/cpanel/scripts/convert_roundcube_mysql2sqlite user litedbfromsql
It returns null and I don't have my contacts and identities back.

• 

  cPanelMichael

  • October 04, 2017 22:08

  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.

  0
• 

  razrdj

  • October 05, 2017 14:35

  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!

  0
• 

  cPanelMichael

  • October 05, 2017 15:36

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

  0
• 

  razrdj

  • October 05, 2017 17:29

  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.

  0
• 

  cPanelMichael

  • October 05, 2017 17:47

  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.

  0
• 

  razrdj

  • October 06, 2017 21:33

  Okay, I will use the export import functionality from RoundCube itself. Thanks Michael :)

  0

Please sign in to leave a comment.