Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Transfer Tool with shared remote MySQL server

Discussion in 'Database Discussion' started by Masimo, Jan 5, 2018.

  1. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Masimo likes this.
  3. Masimo

    Masimo Well-Known Member

    Joined:
    Nov 19, 2015
    Messages:
    70
    Likes Received:
    2
    Trophy Points:
    8
    Location:
    Tbilisi
    cPanel Access Level:
    Root Administrator
    Thank you!
    Hope to be release soon, i have two huge server pending upgrade and transfer :)
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. Novin

    Novin Registered

    Joined:
    Aug 22, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Hello,
    So far looking forward to fix this bug.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

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

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. Novin

    Novin Registered

    Joined:
    Aug 22, 2013
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    Thank you,
    When fix this case?
    We are waiting for a few months.
    Please ....
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    43,711
    Likes Received:
    1,794
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    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.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice