Mysql logical backup mysqldump Syntax: mysqldump [arguments]> file_name if you want to back up all databases, you can use the -- all-databases option: mysqldump -- all-databases> dump. SQL www.2cto.com if you want to back up the specified database, you can use the -- databases option: mysqldump -- databases db1 db2 db3> dump. if you want to back up the test architecture, use the following statement: mysqldump -- single-transaction test> test_backup. SQL use the -- single-transaction option to ensure backup consistency. -- Single-trasaction: run the start transaction command before the backup starts to obtain the backup consistency. Currently, this parameter is only valid for the InnoDB Storage engine. When this parameter is enabled and backed up, make sure that no other DDL statements are executed, because consistency cannot isolate DDL statements. Www.2cto.com -- add-drop-database: drop database before create database. This parameter must be used together with the-all-databases or-databases option. By default, the exported text file does not contain the create database unless you specify this parameter.