mysql diff and add diff records into new database I have two database on two different hosts:

host A has database A and table A

table A contains records with primary key 1 to 10


host B has database B and table B

table B contains records with primary key 1 to 5



Now I have to take a diff of the two separate host/databases/tables
i.e. &quot;host A/database A/table A&quot; contains 1-10 and &quot;host B/database B/table B&quot; contains 1-5 so records 6-10 are missing in host B/database B/table B. Now add these diff records into &quot;host B/database B/table B&quot; from &quot;host A/database A/table A&quot;.
In short, update development database with new production data since last update.
What I have tried:
mysqldump  --replace --complete-insert --skip-disable-keys --no-create-info -h A
  --port=3306 -u A --password=A database_A table_A 
  | mysql -h B -u B --password=B database_B
mysqldump --insert-ignore --extended-insert=FALSE  --complete-insert 
  --skip-disable-keys --no-create-info -h A --port=3306 -u A 
  --password=A database_A table_A | mysql -h B -u B --password=B database_B

--insert-ignore eventually worked as diff and made the rows unique while dumping data across database.