mysqldumpコマンドを使う（その２）

mysqldumpコマンドは、オプションが豊富。
今回使えそうなオプションを上げてみると、

-t, --no-create-info
                    Don't write table creation info.

-r, --result-file=name
                    Direct output to a given file. This option should be used
                    in MSDOS, because it prevents new line '\n' from being
                    converted to '\r\n' (carriage return + line feed).

--opt               Same as --add-drop-table, --add-locks, --create-options,
                    --quick, --extended-insert, --lock-tables, --set-charset,
                    and --disable-keys. Enabled by default, disable with
                    --skip-opt.

--order-by-primary  Sorts each table's rows by primary key, or first unique
                    key, if such a key exists.  Useful when dumping a MyISAM
                    table to be loaded into an InnoDB table, but will make
                    the dump itself take considerably longer.