Re[2]: mysql server move

[Marek Podmaka <marki@onee.sk>]

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