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 SLAVE, DROP DATABASE db1 and db2
- mysql < dbout
- CHANGE MASTER TO... master info
- SLAVE START
The problem is now the slave is saying there are duplicate key entries.
Im not sure
how this is possible. Any thoughts ?
thanks,
M
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]