Re: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-12 Thread Johan De Meersman
nnections. > > Regards, > Gavin Towey > > -Original Message- > From: Andrew Braithwaite [mailto:andrew.braithwa...@lovefilm.com] > Sent: Tuesday, August 11, 2009 8:38 AM > To: mysql@lists.mysql.com > Subject: RE: Replication - connecting a slave to a master on the

RE: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-11 Thread Gavin Towey
2009 8:38 AM To: mysql@lists.mysql.com Subject: RE: Replication - connecting a slave to a master on the same host via a port or socket Ah. I have found that if you use 'localhost' to connect, you cannot specify a port, it silently fails... You can connect using a hostname (even though

RE: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-11 Thread Andrew Braithwaite
..@lovefilm.com] Sent: 11 August 2009 16:12 To: mysql@lists.mysql.com Subject: Replication - connecting a slave to a master on the same host via a port or socket Hi, I have 2 mysql instances running on a server on different ports with different datadirs and different .sock files. I can connect

Replication - connecting a slave to a master on the same host via a port or socket

2009-08-11 Thread Andrew Braithwaite
Hi, I have 2 mysql instances running on a server on different ports with different datadirs and different .sock files. I can connect locally via the sock with the -S flag to mysql but I cannot connect locally via port (-P flag). Does anyone know if there is a way to configure a mysql slave to us