mysqldump Exporting Multiple databases

Mysqldump-uroot-p111111-q-e-r-X--databases account game_s1 game_s2 ... > D:\backup.sql #自己用过的备份参数 for everyone's reference

mysqldump More usage Reference http://blog.csdn.net/allen_a/article/details/51330658

–quick,-q
This option is useful when exporting large tables, forcing mysqldump to cache records directly from the server query instead of getting all the records back into memory.

--extended-insert,-E
Use the Insert syntax with multiple values columns. This makes the export file smaller and speeds up the import. The default is on, using the--skip-extended-insert cancel option.

--single-transaction
This option submits a begin SQL statement before exporting the data, and begin does not block any applications and ensures consistent state of the database at the time of export. It only works with multiple versions of the storage engine, only InnoDB. This option and the--lock-tables option are mutually exclusive because lock tables causes any pending transactions to be implicitly committed. To export large tables, you should use the--quick option together. In this case, it doesn't play a role in accelerating speed.
Mysqldump-uroot-p--host=localhost--all-databases--single-transaction

-T exports table data only and does not export table structure –QUICK,-Q
This option is useful when exporting large tables, forcing mysqldump to cache records directly from the server query instead of getting all the records back into memory.

--extended-insert,-E
Use the Insert syntax with multiple values columns. This makes the export file smaller and speeds up the import. The default is on, using the--skip-extended-insert cancel option.

--single-transaction
This option submits a begin SQL statement before exporting the data, and begin does not block any applications and ensures consistent state of the database at the time of export. It only works with multiple versions of the storage engine, only InnoDB. This option and the--lock-tables option are mutually exclusive because lock tables causes any pending transactions to be implicitly committed. To export large tables, you should use the--quick option together. In this case, it doesn't play a role in accelerating speed.
Mysqldump-uroot-p--host=localhost--all-databases--single-transaction

-T exports table data only, not table structure

--routines,-R

Export stored procedures and custom functions.

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

--lock-all-tables,-X

The commit request locks all tables in all databases to ensure data consistency. This is a global read lock, and the--single-transaction and--lock-tables options are turned off automatically.

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

mysqldump Exporting Multiple databases