1. 导出mysql数据
show variables like '%secure%' 查询出secure_file_priv地址;
在secure_file_priv地址下mkdir aaa;
修改文件权限chmod -R 777 aaa;
select * from i18n_message into outfile '/tmp/etl/temp.dat' fields terminated by ''';
2. 下载数据并上传至GaussDb服务器
3. 导入gaussDb
COPY I18N_MESSAGE FROM '/home/gaussdba/app/bin/temp.dat' WITH DELIMITER '''';