Mysqldump export multiple databases

Mysqldump-uroot-p111111-q-e-R-x -- databasesaccountgame_s1game_s2 ...... d: backup. SQL # self-used backup parameters for your reference. For more use of mysqldump, refer to blog. csdn. netallen_aarticledetails51330658-quick,-q this option is useful when exporting large tables

Mysqldump-uroot-p111111-q-e-R-x -- databases account game_s1 game_s2 ...... d: \ backup. SQL # self-used backup parameters, for your reference mysqldump more use method reference http://blog.csdn.net/allen_a/article/details/51330658-quick,-q this option is useful in exporting large tables

Mysqldump-uroot-p111111-q-e-R-x -- databases account game_s1 game_s2 ......> d: \ backup. SQL # self-used backup parameters for your reference

Mysqldump more common method reference http://blog.csdn.net/allen_a/article/details/51330658

-Quick,-q
This option is useful when exporting large tables. It forces mysqldump to retrieve records from the Server query and output them directly instead of caching all records into the memory.

-- Extended-insert,-e
Use the INSERT syntax with multiple VALUES columns. In this way, the exported file is smaller and the import speed is accelerated. The value is enabled by default, and the -- skip-extended-insert cancel option is used.

-- Single-transaction
This option submits a begin SQL statement before exporting data. BEGIN does not block any applications and ensures Database Consistency during export. It is only applicable to multi-version storage engines and only InnoDB. This option and the -- lock-tables option are mutually exclusive, Because lock tables will implicitly commit any pending transactions. To export a large table, use the -- quick option. This example does not accelerate the speed.
Mysqldump-uroot-p -- host = localhost -- all-databases -- single-transaction

-T: only export table data, not export table structure-quick,-q
This option is useful when exporting large tables. It forces mysqldump to retrieve records from the Server query and output them directly instead of caching all records into the memory.

-- Extended-insert,-e
Use the INSERT syntax with multiple VALUES columns. In this way, the exported file is smaller and the import speed is accelerated. The value is enabled by default, and the -- skip-extended-insert cancel option is used.

-- Single-transaction
This option submits a begin SQL statement before exporting data. BEGIN does not block any applications and ensures Database Consistency during export. It is only applicable to multi-version storage engines and only InnoDB. This option and the -- lock-tables option are mutually exclusive, Because lock tables will implicitly commit any pending transactions. To export a large table, use the -- quick option. This example does not accelerate the speed.
Mysqldump-uroot-p -- host = localhost -- all-databases -- single-transaction

-T only exports table data, not the table structure

-- Routines,-R

Export stored procedures and user-defined functions.

Mysqldump-uroot-p -- host = localhost -- all-databases -- routines

-- Lock-all-tables,-x

Submit a request to lock all tables in all databases to ensure data consistency. This is a global read lock and the -- single-transaction and -- lock-tables options are automatically disabled.

Mysqldump-uroot-p -- host = localhost -- all-databases -- lock-all-tables