<div>
Did you check the option --insert-ignore which does the same job as that of &quot;ON DUPLICATE KEY UPDATE&quot;
</div>


<div>
I thought insert ignore just skipped over those statements? &nbsp;Does it update those records instead? &nbsp;Or does it just &quot;ignore&quot; them and move forward.<br />

</div>


<div>
<a href="http://dev.mysql.com/doc/refman/5.1/en/insert.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/insert.html</a>:<br />
<i>With IGNORE, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; the row still is not inserted, but no error is issued. </i><br />
<br />
Use --replace<br />
<a href="http://dev.mysql.com/doc/refman/5.1/en/replace.html" rel="ugc">http://dev.mysql.com/doc/refman/5.1/en/replace.html</a>:<br />
<i>REPLACE works exactly like &nbsp; &nbsp; &nbsp; INSERT, except that if an old row &nbsp; &nbsp; &nbsp; in the table has the same value as a new row for a &nbsp; &nbsp; &nbsp; PRIMARY KEY or a UNIQUE &nbsp; &nbsp; &nbsp; index, the old row is deleted before the new row is inserted</i><br />

</div>


<div>
My bad you are abs right..... it just ignores that instead of updating... I don't think there is any way thru which (from mysqldump) you can do that,,,, but you can replace STRING INSERT INTO with REPLACE and do the same... it does update..
</div>


<div>
Oh I skipped the answer: It ignores the rows and gives a warning instead of an error.<br />

</div>


<div>
I don't want to replace the record, I want to update it. &nbsp;<br />
<br />
<a href="http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html" rel="ugc">http://dev.mysql.com/doc/refman/5.0/en/insert-on-duplicate.html</a><br />
<br />
INSERT INTO table (a,b,c) VALUES (1,2,3)<br />
&nbsp; ON DUPLICATE KEY UPDATE c=c+1;<br />
<br />
<br />
<br />

</div>


<div>
I also pointed that - &quot;<b>I don't think there is any way thru which (from mysqldump) you can do that,,,,</b> but you can replace STRING INSERT INTO with REPLACE and do the same... it does update.&quot;<br />
<br />

</div>


<div>
<div class="content wysiwyg-content">
Is there a way to generate a mysqldump file that uses the INSERT ... ON DUPLICATE KEY UPDATE syntax? &nbsp;Looking through the mysqldump options right now, but so far, I don't see it.... 
</div>
</div>


Is there a way to generate a mysqldump file that uses the INSERT ... ON DUPLICATE KEY UPDATE syntax?  Looking through the mysqldump options right now, but so far, I don't see it.... 

MySQL - Dumpfile w/ Insert... On Duplicate Update...

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.