Thats exactly what I did. Still the same error.... Show master status shows it running with a positive number. Slave is running. Netstat -na shows them connected. I read that one page for two hours last night... over and over and over :)
Thanks. Lewis ----- Original Message ----- From: "Jeff Kilbride" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Lewis Watson" <[EMAIL PROTECTED]> Cc: "mysql" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 2:45 PM Subject: Re: Replication Error > 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