Marten Lehmann, on 09/03/2007 10:10 AM said:
> Hello,
>
> I couldn't find an option within mysql 5.0.x to get a dump of all rows
> of a table with one line per row/record. I always get insert statements
> with all rows at once. Has that option been removed since 4.1.x?
>

Try --extended-insert=0 which should disable that. From MySQL 5.0.48
mysqldump man page:


To get a list of the options your version of mysqldump supports,
execute mysqldump --. You can disable options with e.g.
--extended-insert=0.

....

· --extended-insert, -e

Use multiple-row INSERT syntax that include several VALUES
lists. This results in a smaller dump file and speeds up
inserts when the file is reloaded.

--
Michael B. Trausch http://www.trausch.us/
Pidgin 2.1.1 and plugins for Ubuntu Feisty!
(And Thunderbird 2.0.0.6, too!) http://www.trausch.us/pidgin