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

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

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

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.

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

RE: need help on replication

2001-05-09 Thread Joseph Chow
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 my first try on this mailing list. I am a new user of mysql