I have read mixed information on this forum about how this should actually work.
Hopefully someone can give me the right answer
We started with server1 and at some point a previous admin decided it would be a good idea to use a remote server just for mySql. So we ended up with server2 hosting MySQL and server1 hosting web/mail/dns/etc.
I now want to move MySQL back to server1 from server2. What I notice is:
All configs for clients use IP of server2 as hostname.
I am surprised because some forum threads here say you can keep the config as localhost and this will be routed via cpanel to the new remote IP. This doesn't seem to be true?
When I migrate all MySQL dbs back from server2 to server1, and I disable remote MySQL in cpanel, I assume I will need to manually change all config to hostname=localhost. Is there any more efficient way to do this?
Thanks in advance
Hopefully someone can give me the right answer
We started with server1 and at some point a previous admin decided it would be a good idea to use a remote server just for mySql. So we ended up with server2 hosting MySQL and server1 hosting web/mail/dns/etc.
I now want to move MySQL back to server1 from server2. What I notice is:
All configs for clients use IP of server2 as hostname.
I am surprised because some forum threads here say you can keep the config as localhost and this will be routed via cpanel to the new remote IP. This doesn't seem to be true?
When I migrate all MySQL dbs back from server2 to server1, and I disable remote MySQL in cpanel, I assume I will need to manually change all config to hostname=localhost. Is there any more efficient way to do this?
Thanks in advance