MySQL Forums
Forum List  »  Replication

Moving data from master to slave using mysqldump
Posted by: harry sheng
Date: March 14, 2014 02:07PM

Hi,
I followed the instructions in mysql document 16.1.1.5 Creating a Data Snapshot Using mysqldump to move data from master to slave.

I dumped the master database with the following command without stop the master datase:
mysqldump --all-databases --master-data > master.dmp

Then import the dumped data into the slave with the following command:
mysql < master.dmp

And I get the following error:
ERROR 1062 (23000) at line 6257: Duplicate entry 'indosat-completeserviceegresspacketoctetslogrecorddaily#P#Monthl' for key 'PRIMARY'

I have a partitioned table completeserviceegresspacketoctetslogrecorddaily in indosat schema.But this table is empty. I have other empty partitioned tables in indosat schema as well. But the import always failed on this particular table.

Options: ReplyQuote


Subject
Views
Written By
Posted
Moving data from master to slave using mysqldump
2717
March 14, 2014 02:07PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.