What are the common backup operation commands for Mysqldump

The following mainly brings you what are the common backup operation commands of Mysqldump. I hope these contents can bring you practical use, which is also the main purpose of this article that I edit the common backup operation commands of Mysqldump. All right, don't talk too much nonsense, let's just read the following.

1.1.1 backup operation

Create user 'backup'@'localhost' identifiedby''

Grant select, reload, lock tables,replication client, show view, event, view, process on *. * to'backup'@'localhost'

Mysqldump-ubackup-p-master-data=2-single-transaction-routines-triggers-events mc_orderdb > mc_orderdb.sql backs up a library

Mysqldump-ubackup-p-master-data=2-single-transaction-routines-triggers-events mc_orderdb table_nametable_name... Xxx.sql backup table

Mysqldump-ubackup-p-master-data=1-single-transaction-routines-triggers-events-all-databases > db.sql backs up the entire instance

Mysqldump-ubackup-p-master-data=2-single-transaction-routines-triggers-events-tab='/xx/xxx' mc_orderdb > xxx.sql sub-table structure and data backup separately

Mysql requires writable access to / xx/xxx

Mysqldump-ubackup-p-master-data=2-single-transaction-where= "order_id > 1000 and order_id