Moving data from master to slave using mysqldump
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.
Subject
Views
Written By
Posted
Moving data from master to slave using mysqldump
2717
March 14, 2014 02:07PM
888
March 15, 2014 08:13AM
804
March 16, 2014 11:01AM
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.