MySQL database data backup and recovery

Backup data:

C:\users\administrator>mysqldump-uroot--password-v test01 test02 >e:\temp\20170507  ****-- connecting to localhost ...  for table test02 ... -- sending SELECT query ... -- Retrieving rows ... --disconnecting from localhost ...

Mysql>Use test01;database changedmysql>Select* FROM test02 to outfile'E:\temp\20170507\a5.sql'- ; ERROR1(HY000): Can't create/write to file'E:emp20170507a5.sql'(Errcode:2-No suchfileor directory) MySQL>Select* FROM test02 to outfile'E:/temp/20170507/a5.sql'; Query OK,8Rows Affected (0.00Sec

Recover data:

Using the Load Data method

' E:/temp/20170507/a5.sql '  8 rows affected (0.038  0  0  0 

Using the Mysqlimport method

C:\users\administrator>mysqlimport--user root--password-v test01 e:/temp/0507/*  file: e:/temp/20170507/8  0   0  0 disconnecting from localhost

MySQL database data backup and recovery