Restore the backup set created by mysqldump

Restore the backup set created by mysqldump

Restore the backup set created by mysqldump:

SQL format recovery

Create a table structure first

Method 1:

[Mysql @ mysql1 ~] $ Mysql-usystem-p123456-S/data/mysqldata/3306/mysql. sock hugc </data/mysqldata/backup/hugc_fullbak. SQL

Method 2:

(System @ localhost) [(none)]> use hugc;

(System @ localhost) [hugc]> source/data/mysqldata/backup/hugc_fullbak. SQL;

Restore the delimiter format

Restore table structure

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

Restore data

(System @ localhost) [mysql]> load data infile '/data/mysqldata/backup/mysql_test.txt 'into table mysql_test fields terminated by', 'enabledby '"';

This article permanently updates the link address: