Re: mysqldump: INSERTS for each individual record.

["Richard AB" <suppressed>]

hello there..

    mysqldump has a option called --opt that dump your data in that way. 
This is the default option for
new versions of mysqldump.
    --opt is the equivalent of  typing --add-drop-table, 
add-locks, --create-options, --quick,
    --extended-insert, --lock-tables, --set-charset and --disable-keys.

    The --extended-insert option is responsible for the behavior you´re 
getting in inserts statement.

    To avoid the --opt option use --skip-opt option and inform other options 
separately...

good luck!!!


Richard AB.


----- Original Message ----- 
From: "Michael Williams" <suppressed>
To: <suppressed>
Sent: Saturday, December 10, 2005 9:50 PM
Subject: mysqldump: INSERTS for each individual record.


When performing  "mysqldump"  is there any way to ensure that each
record gets an INSERT of it's own?  I keep getting the following:

INSERT INTO  'mytable' (1,'test item'), (2,'test item'), (3,'test
item'), (4,'test item'), (5,'test item');

but I'd rather have

INSERT INTO  'mytable' (1,'test item');
INSERT INTO  'mytable' (2,'test item');
INSERT INTO  'mytable' (3,'test item');
INSERT INTO  'mytable' (4,'test item');
INSERT INTO  'mytable' (5,'test item');

because I'm doing my own line diff between files and it's much easier
for me to have the items on individual lines.  Any assistance would
be appreciated.

Regards,
Michael

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: 
http://lists.mysql.com/suppressed



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




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


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed