The problem is now the slave is saying there are duplicate key entries.
Im not sure
how this is possible. Any thoughts ?
Your procedure looks right. Do you use innodb tables?
Otherwise, single-transaction does not work as you expect.
--
MySQL General Mailing List
For list archives: http://l
We had to rebuild the slave on our slave DB. After the raid got rebuilt
replication
broke. We tried to rebuild it from scratch by doing the following:
- RESET MASTER (on master)
- mysqldump -e --master-data --single-transaction --databases db1 db2 >
dbout
- on the slave: STOP SLAVE, RESET SLA
