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
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
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