View Single Post
Old 9th September 2010, 13:07
Mark_NL Mark_NL is offline
Senior Member
Join Date: Sep 2008
Location: The Netherlands
Posts: 912
Thanks: 12
Thanked 100 Times in 96 Posts

You should try and understand the slave_mysql_log.txt file ..

100909 11:11:48 [ERROR] Slave SQL: Error 'Duplicate entry '693' for key 'PRIMARY'' on query. Default database: 'web2project'. Query: 'INSERT INTO `user_access_log`(`user_id`,`date_time_in`,`user_ip`) VALUES ('1',NOW(),'')', Error_code: 1062
Looks pretty straight forward to me ..

you're replication is inconsistent and needs to be setup all over again ..

stop slave on pc2
lock tables on pc1
read master log pos on pc1
mysqldump from pc1
unlock tables on pc1
import mysqldump in pc2
set masterlog pos on pc2
start slave on pc2

Reply With Quote