cPanel account restore does not work for remote mysql profile

gnusys

Well-Known Member
Jan 18, 2013
52
13
58
cPanel Access Level
DataCenter Provider
I have a cPanel server with local mysql service having some accounts .

These accounts are now migrated to a server using cPanels transfer tool where there is no local mysql profile;but a remote mysql profile only. The account restore fails with a warning that mysql restore has failed .

On checking the remote mysql server I could find that none of the mysql databases has been restored!.

Is this how it works?. If yes I think it should be rectified . The restore should work to what ever mysql profile is active on the server to which the accounts are restored.
 

24x7ss

Well-Known Member
Sep 30, 2014
272
17
68
India
cPanel Access Level
Root Administrator
Twitter
Hello :),

The issue might be related to the MySQL version. Please check if the MySQL version is same on both the servers.
Also try restoring the cpmove file manually.
 

gnusys

Well-Known Member
Jan 18, 2013
52
13
58
cPanel Access Level
DataCenter Provider
Actually I was able to fix this . The issue was that I was adding the mysql server via lan IP (the profile has the lan IP) ;but cpanel automatically added only the grants from the cpanel main IP(public IP). The workaround is to add the lan IP in "additional mysql access hosts section"

Would have been great if cPanel automatically detect the connection going via the lan ip and add the grants for this IP rather than the wan IP.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
Hello :)

Internal case CPANEL-2825 is open to address an issue where activating a remote MySQL profile doesn't add local IP grants for users in new account creations or account transfers. There's currently no specific time frame on a resolution, but you can monitor our change log for this case number at:

Change Logs - Documentation - cPanel Documentation

Thank you.