OUTFILE

备份的功能和效果取决于如何写SQL语句

使用方式

首先查询MySQL的导出路径

mysql> show variables like '%secure%';
+--------------------------+-----------------------+
| Variable_name            | Value                 |
+--------------------------+-----------------------+
| require_secure_transport | OFF                   |
| secure_auth              | ON                    |
| secure_file_priv         | /var/lib/mysql-files/ |
+--------------------------+-----------------------+
3 rows in set (0.00 sec)

使用into outfile指令将查询结果导出至文件

select * into outfile '/var/lib/mysql-files/out_file_test' from t1;

[root@VM-20-6-centos ~]# cat /var/lib/mysql-files/out_file_test;
4    6
6    3
7    1