Re: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread SGreen
An IP socket is the unique combination of an IP address and a port number. I don't see why you couldn't run those separate instances of your db servers on the same port but each with their own addresses as they would each have their own unique IP socket. I don't think you would create any

Re: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread SGreen
I need to add to my previous post -- You asked about using the SAME operating system socket as well as using separate addresses with the same port number (different IP sockets) My answer to that is NOT ON YOUR LIFE. Think of the chaos. If one client tried to connect to an OS socket that 3

RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Peter Lovatt
:[EMAIL PROTECTED] Sent: 09 September 2004 14:53 To: Sanjeev Sagar Cc: [EMAIL PROTECTED]; Sanjeev Sagar Subject: Re: Multiple MysQL servers with different IP address on same machine I need to add to my previous post -- You asked about using the SAME operating system socket as well as using

RE: Multiple MysQL servers with different IP address on same machine

2004-09-09 Thread Sanjeev Sagar
] Sent: Thu 9/9/2004 9:51 AM To: [EMAIL PROTECTED]; Sanjeev Sagar Cc: [EMAIL PROTECTED]; Sanjeev Sagar Subject: RE: Multiple MysQL servers with different IP address on same machine Hi We have a machine with 2 IP addresses and mysql 3.23 on one and 4.10 on the other. Both using port 3306 One

Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread Sanjeev Sagar
Hello All, MySQL : Standar Binary 4.0.20 O/S : Red Hat Linux release 9 (Shrike) Linux 2.4.20-31.9smp #1 SMP Tue Apr 13 17:40:10 EDT 2004 i686 i686 i386 GNU/Linux I already have setup of Three Multiple MySQL servers listening on different ports and sockets on same machine Option File:

Re: Multiple MysQL servers with different IP address on same machine

2004-09-08 Thread leegold
The example below renames a col. But can I rename a col. w/out giving all that type spec. at the end of the statement below. I just want to rename everything else stays the same. Thanks. mysql ALTER TABLE search CHANGE Description PageDescription VARCHAR(255) NOT NULL; -- MySQL General Mailing