Mysqldump Common Command Options

-A--all-databases back up all databases

-B--databases backing up the specified database, you can specify multiple library names at the same time

-D backs up the table structure only

-T backs up table data only

-T--tab separates table structure from table data in plain text format, not SQL statement, followed by path

-F Refresh the Binlog log to generate a new Mysql-bin file

-MASTER-DATA=[1|2] 1 means that the log file and pos,2 are recorded as annotations, and 2 is commonly used for backup.

-X--lock-all-tables Lock all tables when backing up

--single-transaction Non-lock table backup for InnoDB engine

-r backup stored procedures and functions

--opt optimizations enabled when backing up, including closing buffers, and writing more statements in less SQL when exporting

--allow-keywords allows reserved words to be used as table names

This article is from the "burning Years of Passion" blog, please be sure to keep this source http://liuzhengwei521.blog.51cto.com/4855442/1881974

Mysqldump Common Command Options