Import DirectAdmin RoundCube database

[razrdj]

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]

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.

 

[razrdj]

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!

 

[cPanelMichael]

Hello,

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

Thank you.

 

[razrdj]

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.

 

[cPanelMichael]

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.

 

[razrdj]

Okay, I will use the export import functionality from RoundCube itself.

Thanks Michael