mysqldump — A Database Backup Program Option Name Description Introduced Deprecated --login-path Read login path options from .mylogin.cnf --master-data Write the binary log file name and position to the output --max-allowed-packet Maximum packet length to send to or receive from server --net-buffer-length Buffer size for TCP/IP and socket communication --network-timeout Increase network timeouts to permit larger table dumps --no-autocommit Enclose the INSERT statements for each dumped table within SET autocommit = 0 and COMMIT statements --no-create-db Do not write CREATE DATABASE statements --no-create-info Do not write CREATE TABLE statements that re-create each dumped table --no-data Do not dump table contents --no-defaults Read no option files --no-set-names Same as --skip-set- charset --no-tablespaces Do not write any CREATE LOGFILE GROUP or CREATE TABLESPACE statements in output --opt Shorthand for --add- drop-table --add-locks -- create-options --disable- keys --extended-insert -- lock-tables --quick --set- charset --order-by-primary Dump each table’s rows sorted by its primary key, or by its first unique index --password Password to use when connecting to server 478