Hi, Jeremy,
It is very nice to talk to you. Thanks for your information. It's working
now, but I did nothing but going over the procedure again. I may make some
mistakes during my operations. But it is really a good idea to keep an eye
on the err log for solutions.
By the way, I once first tried to set up the slave on a NT machine. But for
"unknown" (means I donot know) reasons, I can not even "net start mysql" on
that machine now. The error message is "system error 5". Did you meet this
problem? If so, how did you solve it?
thanks alot,
Joe
-----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 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 values ..) on the master server were
> mirrored by the slave server. However, after I dumped some
> databases from the master to the slave, the bad things happened.
> The connection between the master and the slave was down. I failed
> to reconnect them by shutting down and restarting the master and the
> slave a couple of times.
You'll need to look in the mysql error log on the slave and see what
it says. That should give us/you a good idea what may have happened.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 126 days, processed 780,401,285 queries (71/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
