Skip to main content

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

Masimo
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: [ 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!

Comments

14 comments

Date Votes
  • cPanelMichael
    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.
    0
  • Masimo
    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.

    Thank you! Hope to be release soon, i have two huge server pending upgrade and transfer :)
    0
  • Novin
    Hello, So far looking forward to fix this bug.
    0
  • cPanelMichael
    Hello, I'll continue to monitor the case and update this thread once it's published. Thank you.
    0
  • Novin
    Hello, I'll continue to monitor the case and update this thread once it's published. Thank you.

    Thank you, When fix this case? We are waiting for a few months. Please ....
    0
  • cPanelMichael
    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 restorepkg Script - Version 70 Documentation - cPanel Documentation Let me know if you have any questions. Thank you.
    0
  • Novin
    Hello, Now published v72, when solve this problem? we cant transfer manually, because huge of server (+4000 Account).
    0
  • cPanelLauren
    Hello, This should be pushed soon for v72 but does not appear to be merged yet. We will update here once it's updated. Thanks!
    0
  • Novin
    Hello, I want transfer server, fix this problem or not? Thanks
    0
  • cPanelMichael
    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.
    0
  • Novin
    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
    0
  • cPanelMichael
    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.
    0
  • cPanelMichael
    Hello Everyone, The fix for CPANEL-16829 will come with cPanel & WHM version 82. You can monitor
    0
  • Mrg
    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.
    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post