Use mysqldump command line tool to create logical backup

Use mysqldump command line tool to create logical backup

The mysqldump command creates a logical backup, and the result set has two formats: one is to convert data into standard SQL statements (a bunch of CREATE, DROP, INSERT, and other statements ), the other is to output data to a flat file in a bounded format according to the specified delimiter.

[Mysql @ mysql1 ~] $ Mysqldump

Usage: mysqldump [OPTIONS] database [tables]

OR mysqldump [OPTIONS] -- databases [OPTIONS] DB1 [DB2 DB3. ..]

OR mysqldump [OPTIONS] -- all-databases [OPTIONS]

For more options, use mysqldump-help

[Mysql @ mysql1 ~] $ Mysqldump-usystem-p123456-S/data/mysqldata/3306/mysql. sock mysql>/data/mysqldata/backup/mysql_fullbak. SQL

[Mysql @ mysql1 ~] $ Mysqldump-usystem-p123456-S/data/mysqldata/3306/mysql. sock -- databases mysql test>/data/mysqldata/backup/mysql_test_fullbak. SQL

[Mysql @ mysql1 ~] $ Mysqldump-usystem-p123456-S/data/mysqldata/3306/mysql. sock -- all-databases>/data/mysqldata/backup/all_fullbak. SQL

Output Format File: delimiter, another storage Object Organization (create table ..........------------

[Mysql @ mysql1 ~] $ Mysqldump-usystem-p123456-S/data/mysqldata/3306/mysql. sock -- tab =/data/mysqldata/backup mysql

Perform the following operations in 5.6:

Add

[Mysqldump]

User = system

Password = 123456

[Mysql @ mysql1 ~] $ Mysqldump-S/data/mysqldata/3306/mysql. sock mysql>/data/mysqldata/backup/mysql_fullbak. SQL

[Mysql @ mysql1 ~] $ Mysqldump-S/data/mysqldata/3306/mysql. sock -- tab =/data/mysqldata/backup mysql

This article permanently updates the link address: