场景:需要将192.168.0.100 /tmp/test001.txt 文件数据导入到192.168.0.101的mysql test_db1.table_tmp
脚本:
mysql="/usr/local/mysql/bin/mysql -h192.168.0.101 -uroot -p123456 test -N"
echo "load data local infile '${tmp_file}' ignore into table test_db1.table_tmp fields terminated by ',' lines terminated by '\n'" | ${mysql}
分析:跟一般导入数据的区别在于,加入了local关键字,表示从客户机(脚本所在机器)导数据到远程机器192.168.0.101的mysql