mysql数据库数据备份与恢复

备份数据：

C:\Users\Administrator>mysqldump -uroot --password -v test01 test02 >e:\temp\\a3.sql

Enter password: ****

-- Connecting to localhost...

-- Retrieving table structure for table test02...

-- Sending SELECT query...

-- Retrieving rows...

-- Disconnecting from localhost...

mysql> use test01;

Database changed

mysql> select * from test02 into outfile 'e:\temp\20170507\a5.sql'

    -> ;

ERROR  (HY000): Can't create/write to file 'e: emp20170507a5.sql' (Errcode: 2 -

 No such file or directory)

mysql> select * from test02 into outfile 'e:/temp/20170507/a5.sql';

Query OK,  rows affected (0.00 sec)

恢复数据：

使用load data方法

mysql> load data infile 'e:/temp/20170507/a5.sql' into table test03;

Query OK,  rows affected (0.03 sec)

Records:   Deleted:   Skipped:   Warnings: 

使用mysqlimport方法

C:\Users\Administrator>mysqlimport --user root --password -v test01 e:/temp/

/test03.sql

Enter password: ****

Connecting to localhost

Selecting database test01

Loading data from SERVER file: e:/temp//test03.sql into test03

test01.test03: Records:   Deleted:   Skipped:   Warnings:

Disconnecting from localhost