From: Dan Nelson (dnelsonallantgroup.com)
Date: Mon Sep 03 2007 - 14:13:09 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

In the last episode (Sep 03), Marten Lehmann said:
> 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?

Add --skip-extended-insert to your mysqldump commandline.

  o --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.

  o --opt

     This option is shorthand; it is the same as specifying
     --add-drop-table --add-locks --create-options --disable-keys
     --extended-insert --lock-tables --quick --set-charset. It should
     give you a fast dump operation and produce a dump file that can be
     reloaded into a MySQL server quickly.

     The --opt option is enabled by default. Use --skip-opt to disable
     it. See the discussion at the beginning of this section for
     information about selectively enabling or disabling certain of the
     options affected by --opt.

--
        Dan Nelson
        dnelsonallantgroup.com

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]