最近在研究使用mycat,其中有使用批量数据导入,简单记录一下使用方式。
查看系统属性
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.03 sec)
我们导出的数据必须制定为/var/lib/mysql-files/,oracle也有类似的设置。
load data 必须指明表,例如我导出表t_card_validate_info2的数据,命令如下
mysql> select * from t_card_validate_info_m into outfile '/var/lib/mysql-files/t_card_validate_info.txt' FIELDS TERMINATED BY '\t' OPTIONALLY ENCLOSED BY '' ESCAPED BY '\\' LINES TERMINATED BY '\n';
Query OK, 24892 rows a