RE: need help on replication
Joe: AFAIR, as an ex NT4 sysadmin, system error 5 is access denied - you have a permissions problem somewhere. On NT4 these can be a swine to solve. Check out your NT system error logs as a starting point. HTH. David 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 - 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
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-7878Fax: (408) 349-5454Cell: (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
RE: need help on replication
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-7878Fax: (408) 349-5454Cell: (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
Re: need help on replication
On Wed, May 09, 2001 at 11:18:14AM -0600, Joseph Chow wrote: 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. Indeed. 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? I can't help you much there. I really only use Windows when there are not other options available to me, so I haven't seen this problem before. Sorry. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 126 days, processed 780,513,289 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