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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Remote MySQL server migration and PHP script behaviour

Discussion in 'Database Discussions' started by jrquint, Mar 30, 2012.

  1. jrquint

    jrquint Registered

    Mar 30, 2012
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    I am contemplating migrating our cPanel 11.30 server to use a remote MySQL server due to server load. I understand that I must move the databases manually (using mysqldump, etc). My main concern is the clients PHP-based sites that use MySQL.

    Almost all of the scripts have some sort of 'host' designation in the mysql connection, and, of course, they are all set to 'localhost'. If I migrate to a remote MySQL server, will all of the clients have to update their PHP to use the new hostname? Or does the my.conf changes 'remap' the localhost requests to the remote server?


Share This Page