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!

Remote MySQL server migration and PHP script behaviour

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

  1. jrquint

    jrquint Registered

    Joined:
    Mar 30, 2012
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    51
    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?

    Thanks!
     
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