Migrate Roundcube contacts and signature by Transfer Tool

[DeviC3]

Hello, I have few cPanel servers and sometimes I need to transfer user accounts via this instances.
Everything is working fine but there are missing Roundcube user contacts for each mail and signatures. Is there way to easy restore them per user account?
Contacts are stored in Mysql on first server but on destination server there is Sqlite.

I was trying to change mysql to sqlite for user by this thread:

How do I convert Roundcube from MySQL to SQLite?

Introduction For a more stable, portable, and faster experience with Roundcube, user databases should be converted to SQLite from MySQL. Warning:If you change Roundcube’s database to an SQLite da...

support.cpanel.net

but output was:

The optional user argument is to be used only when Roundcube has been converted to sqlite. Use bin/update-roundcube-sqlite-db Exiting.

 

[quietFinn]

I was trying to change mysql to sqlite for user by this thread:

How do I convert Roundcube from MySQL to SQLite?

Introduction For a more stable, portable, and faster experience with Roundcube, user databases should be converted to SQLite from MySQL. Warning:If you change Roundcube’s database to an SQLite da...

support.cpanel.net

In that page it says:
"Note, all users on a system must use the same database format. You cannot use this script to convert just one user and leave the rest using MySQL."

 

[cPRex]

As @quietFinn mentioned, it would be best to convert the entire Source machine before attempting the move to the Destination in order to ensure things work well.

 

[DeviC3]

Thank You for replies. So is there way to transfer all contacts assigned to each email account in only one user account ? I can write script to get this data from Mysql to Mysql but I have no idea how to do this from Mysql to Sqlite

 

[cPRex]

I don't have any tools on my end that would automatically or manually perform that type of work on either type of database. The best way to do it would likely be to look into the database structure itself on the SQLite side and construct a script to work with that.