Import DirectAdmin RoundCube database

razrdj

Active Member
Oct 1, 2013
26
1
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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

Active Member
Oct 1, 2013
26
1
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!
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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

Active Member
Oct 1, 2013
26
1
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,216
463
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.