Re: mysqldump: getting it to dump INSERT IGNORE

2005-12-11 Thread Richard AB

Hi.

   Use the --insert-ignore option of mysqldump.

   You can type 'mysqldump --help' on command line to see all options available.



Richard AB.


- Original Message - 
From: "Michael Williams" <[EMAIL PROTECTED]>

To: 
Sent: Sunday, December 11, 2005 6:19 PM
Subject: mysqldump: getting it to dump INSERT IGNORE



Hi All,

I have read thehttp://dev.mysql.com/doc/refman/5.0/en/ 
mysqldump.html and can find nothing regarding getting dump to  
INSERT IGNORE instead of simply INSERT INTO.  Is there any way to get  
INSERT IGNORE to be dumped?  Otherwise, I fear I may be forced to  
parse the dump file and do a few replacements.


Regards,
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/197 - Release Date: 09/12/2005





--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.13.13/197 - Release Date: 09/12/2005


--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



mysqldump: getting it to dump INSERT IGNORE

2005-12-11 Thread Michael Williams

Hi All,

I have read thehttp://dev.mysql.com/doc/refman/5.0/en/ 
mysqldump.html and can find nothing regarding getting dump to  
INSERT IGNORE instead of simply INSERT INTO.  Is there any way to get  
INSERT IGNORE to be dumped?  Otherwise, I fear I may be forced to  
parse the dump file and do a few replacements.


Regards,
Michael

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]