Mysqldump update table

Question

I use the mysqldump utility to dump the database on the test server, which runs on the crown.

  Mysqldump --host = 127.0.0.1 --skip-add-drop-table --skip-add-locks --no-create-info --user = root --password = 'root' stead> tead.sql

 On production for import use:

    Mysql --user = root --password = 'root' test

It also starts on the crown.

The dump file contains approximately the following information.

 INSERT INTO im_gruppy VALUES (100, 'Paper for office equipment', 1, '100.png', 1);

 The problem is that when insert finds Duplicate entry '1' for key 'PRIMARY', import stops. And I would like to update the old records.

Prompt as it is possible by means of mysqldump and mysql to do update lines and if a line is not present that insert?

Answer 1

mysqldump --host=127.0.0.1 --skip-add-drop-table --skip-add-locks --no-create-info --replace --user=root --password='root' stead > tead.sql