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 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
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 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
need help on "replication"
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. So, here are my questions: 1> Does "myadmindump .." command have anything to do the disconnection? 2> How could I reconnect them now? If you could take a minute to help me out, I'd much appreciated. thanks, Joe Chow - 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
