mysqldump — A Database Backup Program Option Name Description Introduced Deprecated corresponding clause for LOAD DATA --fields-terminated-by This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA --flush-logs Flush MySQL server log files before starting dump --flush-privileges Emit a FLUSH PRIVILEGES statement after dumping mysql database --force Continue even if an SQL error occurs during a table dump --get-server-public-key Request RSA public key from server --help Display help message and exit --hex-blob Dump binary columns using hexadecimal notation --host Host on which MySQL server is located --ignore-error Ignore specified errors --ignore-table Do not dump given table --include-master-host- port Include MASTER_HOST/ MASTER_PORT options in CHANGE MASTER statement produced with --dump-slave --insert-ignore Write INSERT IGNORE rather than INSERT statements --lines-terminated-by This option is used with the --tab option and has the same meaning as the corresponding clause for LOAD DATA --lock-all-tables Lock all tables across all databases --lock-tables Lock all tables before dumping them --log-error Append warnings and errors to named file 477