SOLVED [CPANEL-16829] Transfer Tool with shared remote MySQL server

Masimo

Well-Known Member
Nov 19, 2015
70
2
8
Tbilisi
cPanel Access Level
Root Administrator
I was getting a cluster configured with two web nodes and a dedicated MySQL server.
When I selected the Databases option when transferring the account, this is what appears in the logs:

Code:
[ 29940][RESTORE:1 ][A:mynewdom ]: Mysql
[ 29940][RESTORE:1 ][A:mynewdom ]: Preparing MySQL restore …
[ 29940][RESTORE:1 ][A:mynewdom ]: The system will not restore MySQL databases because this system shares a MySQL server with the source system.
[ 29940][RESTORE:1 ][A:mynewdom ]: Restoring MySQL privileges
[ 29940][RESTORE:1 ][A:mynewdom ]: Restoring MySQL grants
[ 29940][RESTORE:1 ][A:mynewdom ]:
[ 29940][RESTORE:1 ][A:mynewdom ]: Restoring MySQL access hosts
[ 29940][RESTORE:1 ][A:mynewdom ]: Storing MySQL Grants
[ 29940][RESTORE:1 ][A:mynewdom ]: Mysql
Because both servers use the same server for MySQL, there's no need to transfer the databases.
Interestingly enough, even though the grants are restored, I'm still unable to view the database in the cPanel account on the new server.

cPanel developers have determined that this is in fact a bug with the Transfer Tool.

The case ID is CPANEL-16829 and should keep an eye on cPanel change log for the update:
68 Change Log - Change Logs - cPanel Documentation

Hope to have an update soon!
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello,

Thank you for sharing. I'll monitor this case and update this thread with more information on it's status as it becomes available.

Thank you.
 
  • Like
Reactions: Masimo

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello,

I'll continue to monitor the case and update this thread once it's published.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello @Novin,

The case is tentatively scheduled for inclusion with cPanel & WHM version 72. I'll update this thread again once it's published. In the meantime, the temporary workaround is to manually backup the account on the source server, move the backup archive to the destination server, and then restore the backup archive on the destination server. We document how to backup and restore accounts from the command line at:

The pkgacct Script - Version 70 Documentation - cPanel Documentation
The restorepkg Script - Version 70 Documentation - cPanel Documentation

Let me know if you have any questions.

Thank you.
 

Novin

Member
Aug 22, 2013
5
0
1
cPanel Access Level
Website Owner
Hello,
Now published v72, when solve this problem?
we cant transfer manually, because huge of server (+4000 Account).
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello @Novin,

Internal case CPANEL-16829 is not yet published and remains open. I don't have a specific time frame to offer at this time, however I'll update this thread with more information as soon as it's available. I've also linked this forums thread to the case to increase awareness.

Thank you.
 

Novin

Member
Aug 22, 2013
5
0
1
cPanel Access Level
Website Owner
Hello,
cPanel v76.0.14 is now Stable.
This problem when publish?
I'm waiting for 3 years, i cant move manually because I have more than +1200 accounts on the server
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello @Novin,

The solution is not included with cPanel & WHM version 76. I don't have a specific time frame to offer at this time, but I'll continue to monitor the case and update this thread with more information as soon as it's available.

Thank you.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,202
363
Hello Everyone,

The fix for CPANEL-16829 will come with cPanel & WHM version 82. You can monitor releases.cpanel.net to see more information about version 82 once it's closer to public release.

Let us know if you have any questions.

Thanks!
 

Mrg

Member
Feb 8, 2012
16
0
51
cPanel Access Level
Root Administrator
We get the same issue with v86.0.18 :

we transfer in new cluster. so local db ip is the same for server from and server to. but the db server is a different one. (because new clsuter in other datacenter). how can we use transfer tool. may we can disable the check.
Preparing MySQL restore …
The system will not restore MySQL databases because this system shares a MySQL server with the source system.