RESET MASTER RESET SLAVE This is a handy page to bookmark, if you're doing replication: http://www.mysql.com/doc/en/Replication_SQL.html
--jeff ----- Original Message ----- From: "walt" <[EMAIL PROTECTED]> To: "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 12:08 PM Subject: Re: Replication Error > Lewis Watson wrote: > > > Also, I am intersted in a way to reset the entire replication thing. In > > other words, just remove all hints of replication and start over... Is there > > a way I can do this? > > Thanks. > > Lewis > > > > ----- Original Message ----- > > From: "Lewis Watson" <[EMAIL PROTECTED]> > > To: "mysql" <[EMAIL PROTECTED]> > > Sent: Tuesday, October 22, 2002 12:06 PM > > Subject: Replication Error > > > > > I had replication running fine between two mysql server machines on linux. > > > Then I added yet another slave but goofed and put in the same server-id. > > Now > > > I am getting errors on the master server and proccesses being killed and > > > restarted. It comes with this error. > > > > > > ./bin/safe_mysqld: line 273: 12250 Segmentation fault > > > $NOHUP_NICENESS $ledir/$MYSQLD > > > $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR > > > $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 > > > > > > I have tried flushing both master and slave. I have also reset eac. I have > > > also deleted the log files and the master.info file on the slave. Nothing > > is > > > allowing these the master and original slave to communicate anymore. Any > > > ideas? > > > Thanks, > > > Lewis > > > > > > > > > > > > --------------------------------------------------------------------- > > > 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 > > > > > > > --------------------------------------------------------------------- > > 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 > > Lewis, > As far as I've been able to see, there are only a few files that control > replication. > I'd try removing replication stuff from my.cnf (server-id, log-bin, etc..) and > stopping mysql on both > the master and the slave. Then delete log files on the master including the > *.index file. I'd then delete > any files on the slave that deal with replication (master.info). > Once all this is done, try restarting the master > to see if it still has problems. > > walt > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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