Re[2]: mysql server move
Hello wim,
I tried that, but it would work only for those users who leave the
host parameter in mysql_connect() empty - and not for those who fill
in "localhost".
I have tried that unix2tcp and it seems it is exactly what I need.
For the first look it seems better than other suggested socat,
because it doesn't fork for each new connection.
Tuesday, July 19, 2005, 11:56:18, wim wrote:
w> Marek Podmaka wrote:
>> Hello,
>>
>> I want to move mysql4 server to new machine, but I have problems
>> with php. I thought that using port redirector (rinetd) would be
>> sufficient until all customers change their php scripts, but it
>> doesn't work.
>>
>> Most people use "localhost" in call to mysql_connect() and php tries
>> to connect using socket - which isn't present if mysqld is running
>> on another box. I tried playing with mysql.default_host and
>> default_port in php.ini, but with no effect.
>>
>> In php manual I have found that php will always try to connect using
>> socket if it finds "localhost". But is there any option how to move
>> database to another box flawlessly?
>>
>>
w> Change your default mysql-server in php.ini?
w> wim.
--
bYE, Marki
Reply to: