Migrate Roundcube contacts and signature by Transfer Tool

DeviC3

Member
Mar 28, 2021
13
0
1
Poland
cPanel Access Level
Website Owner
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:

but output was:
Code:
The optional user argument is to be used only when Roundcube has been converted to sqlite. Use bin/update-roundcube-sqlite-db Exiting.
 
Last edited:

quietFinn

Well-Known Member
Feb 4, 2006
1,394
178
193
Finland
cPanel Access Level
Root Administrator
I was trying to change mysql to sqlite for user by this thread:
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."
 
  • Like
Reactions: cPRex

DeviC3

Member
Mar 28, 2021
13
0
1
Poland
cPanel Access Level
Website Owner
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

Jurassic Moderator
Staff member
Oct 19, 2014
7,519
1,028
313
cPanel Access Level
Root Administrator
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.
 
  • Like
Reactions: DeviC3