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/[EMAIL PROTECTED]
