在远程计算机上加载数据文件 [英] LOAD DATA INFILE on remote machine
本文介绍了在远程计算机上加载数据文件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我如何在远程数据库(不同的机器)上使用本地文件执行以下命令?
How would I do the following command, with a local file, on a remote database (different machine) ?
$MYSQL_PATH/mysql -u root -h remote.net files -e "
LOAD DATA INFILE '$1'
INTO TABLE $TABLE_NAME
FIELDS TERMINATED BY ','
(size, @d2, @d3, @d4, @d5, path)
问题似乎是在/tmp/infile.txt
处的INFILE无法被远程识别.完成上述任务的正确方法是什么?
The problem seems to be that the INFILE at /tmp/infile.txt
is not being recognized remotely. What would be the correct way to accomplish the above?
推荐答案
LOAD DATA INFILE
在运行MySQL服务器的计算机上加载文件.
LOAD DATA INFILE
loads a file on machine the MySQL server is running on.
使用LOAD DATA LOCAL INFILE
加载位于客户端计算机上的文件.
Use LOAD DATA LOCAL INFILE
to load a file located on your client machine.
这篇关于在远程计算机上加载数据文件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文