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?