I was hoping not to have to do that... Jeff McKeon IT Manager Telaurus Communications LLC [EMAIL PROTECTED] (973) 889-8990 ex 209
***The information contained in this communication is confidential. It is intended only for the sole use of the recipient named above and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication, or any of its contents or attachments, is expressly prohibited. If you have received this communication in error, please re-send it to the sender and delete the original message, and any copy of it, from your computer system. Thank You.*** > -----Original Message----- > From: Primaria Falticeni [mailto:[EMAIL PROTECTED] > Sent: Monday, July 21, 2003 12:27 PM > To: MySQL LIST > Subject: Re: Slave not working.... > > > Try recreate the replication (shut down the servers, copy the > master database into the slave place and so on). > > ----- Original Message ----- > From: "Jeff McKeon" <[EMAIL PROTECTED]> > To: "MySQL List" <[EMAIL PROTECTED]> > Sent: Monday, July 21, 2003 7:20 PM > Subject: Slave not working.... > > > > I had a power failure on the master and it bounced rather > > ungracefully. Now I'm getting this error on the slave and it's not > > replicating. Both are ver 3.23 > > > > mysql> slave start; > > Query OK, 0 rows affected (0.00 sec) > > > > mysql> show slave status \G; > > *************************** 1. row *************************** > > Master_Host: 10.32.1.10 > > Master_User: repli > > Master_Port: 3306 > > Connect_retry: 60 > > Log_File: db01tc0927-bin.035 > > Pos: 73 > > Slave_Running: No > > Replicate_do_db: > > Replicate_ignore_db: > > Last_errno: 1062 > > Last_error: error 'Duplicate entry '245937' for key 1' on > > query '%' > > Skip_counter: 0 > > 1 row in set (0.00 sec) > > > > ERROR: > > No query specified > > > > How do I fix this? > > > > Jeff McKeon > > IT Manager > > Telaurus Communications LLC > > [EMAIL PROTECTED] > > (973) 889-8990 ex 209 > > > > ***The information contained in this communication is > confidential. It > > is intended only for the sole use of the recipient named > above and may > > be legally privileged. If the reader of this message is not the > > intended recipient, you are hereby notified that any dissemination, > > distribution or copying of this communication, or any of > its contents > > or attachments, is expressly prohibited. If you have received this > > communication in error, please re-send it to the sender and > delete the > > original message, and any copy of it, from your computer > system. Thank > > You.*** > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
