question about replication under version 3.23.38 for Unix (database)

2001-05-21 Thread Joseph Chow
HI, everyone, I met a problem about setting up replication(master/slave) of mysql sever on unix boxes. Mysql servers are installed under "/usr/local/" on master and slave and they can be run under "/usr/local/mysql/bin". It seems to me that I have three choices where to put my configuration f

question about a select application (sql, database)

2001-05-18 Thread Joseph Chow
Hi, everyone, I wrote a program to keep inserting rows to the databases. But I want to check the LAST row I inserted. Is there any good way to do it?? thanks, Joe

2-way replication in MySQL (sql)

2001-05-11 Thread Joseph Chow
Hi, everyone, This is my another question. I have one master server and one slave server now. In case that the master is down for any reason, I want the slave still accessible by clients. Is that possible in my SQL? by two way replications? This problem seems quiet complicated to me. Please

MySQL -- tee command ???

2001-05-11 Thread Joseph Chow
Hi, everyone, I have a question about the "tee" command in MySQL. I know one of its applications is to log everything from the screen to the outfile for debugging purpose. But how do I redirect output ONLY to outfile instead of both standard output (screen) and outfile. Because I donot want

RE: need help on "replication"

2001-05-09 Thread Joseph Chow
e -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 09, 2001 10:33 AM To: Joseph Chow Cc: [EMAIL PROTECTED] Subject: Re: need help on "replication" On Wed, May 09, 2001 at 10:29:42AM -0600, Joseph Chow wrote: > Hi, there, > > This is

need help on "replication"

2001-05-09 Thread Joseph Chow
Hi, there, This is my first try on this mailing list. I am a new user of mysql and need some help about "replication" on mysql 3.23.36. I had followed the manual to set up master/slave server. At the beginning, they are connected perfectly. All the modifications (i.e. create databases, insert