blocks|key|3028334|text|尝试使用LOAD+DATA+LOCAL+INFILE而不是LOAD+DATA+INFILE|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|3028335|否则，请检查您的目录的apparmor是否处于活动状态|3028336|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/AppArmor^0|4|M|T|G|0|B|8|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|G|5|6|7|U|8|@]|D|@$9|V|A|W|1|X]]|E|$]]|$1|H|3|-4|5|6|7|Y|8|@]|D|@]|E|$]]]|I|$J|$5|K|L|M|E|$N|O]]]]

try to use <code>LOAD DATA LOCAL INFILE</code> instead of <code>LOAD DATA INFILE</code> 

otherwise check if <a href="http://en.wikipedia.org/wiki/AppArmor" rel="noreferrer">apparmor</a> is active for your directory

blocks|key|302895|text|我也遇到过类似的问题。这个解决方案有点丑陋，但是如果你能“sudo”的话，比起apparmor的变通方法来更容易记住。首先，我必须将输入文件放在我正在使用的数据库的MySQL子目录中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|302896|sudo+cp+myfile.txt+/var/lib/mysql/mydatabasename|code-block|syntax|javascript|302897|这将执行一次复制，并将'root‘保留为文件所有者。进入mysql并执行USE+mydatabasename之后，我能够使用以下命令填充适当的表|offset|length|style|CODE|302898|LOAD+DATA+INFILE+'mytabdelimitedtextfile.txt'+INTO+TABLE+mytablename;|302899|entityMap^0|0|0|C|4|10|I|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@$I|T|J|U|K|L]|$I|V|J|W|K|L]]|9|@]|A|$]]|$1|M|3|N|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|P|$]]

I had a similar problem. The resolution was a mildly ugly hack, but much easier to remember than apparmor workarounds provided that you can 'sudo'. First, I had to put the input file in the mysql sub-directory for the database I was using:

<pre><code>sudo cp myfile.txt /var/lib/mysql/mydatabasename
</code></pre>

This does a copy and leaves '<code>root</code>' as the file owner. After getting into mysql and doing a <code>USE mydatabasename</code>, I was able to populate appropriate table using

<pre><code>LOAD DATA INFILE 'mytabdelimitedtextfile.txt' INTO TABLE mytablename;
</code></pre>

blocks|key|3028374|text|使用--local参数会对此有所帮助。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028375|示例:+mysqlimport+--本地数据库名称file.txt+-p|3028376|来源：http://dev.mysql.com/doc/refman/5.1/en/load-data.html“--local选项使mysqlimport从客户端主机读取数据文件”|offset|length|3028377|entityMap|0|LINK|mutability|MUTABLE|url|http://dev.mysql.com/doc/refman/5.1/en/load-data.html^0|0|0|3|1H|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Using --local parameter will help with this.

Example: mysqlimport --local databasename file.txt -p

source:
<a href="http://dev.mysql.com/doc/refman/5.1/en/load-data.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.1/en/load-data.html</a>
"The --local option causes mysqlimport to read data files from the client host"

blocks|key|300076|text|对我来说，将内容复制到/tmp并用作源文件夹就行了。我使用MariaDB，并且我的版本不允许使用“本地”修饰符。有趣的是，授予对CSV文件夹的读写访问权限也不起作用。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|300077|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

For me, copying the contents to /tmp and using that as the source folder did the trick.
I use MariaDB, and my version does not allow using the "LOCAL" modifier.
Interestingly, giving read-write access to the CSV folder did not work either.

blocks|key|3028416|text|在AWS实例上用mysql填充表时，我也遇到了同样的问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3028417|在我的例子中，csv文件在实例本身中。|3028418|使用绝对路径解决了我的问题。|3028419|下面是MySQL文档中的代码行|3028420|3028421|如果指定了LOCAL，则文件由客户端主机上的客户端程序读取并发送到服务器。可以将该文件指定为完整路径名，以指定其确切位置。如果指定为相对路径名，则该名称将相对于启动客户端程序的目录进行解释。|blockquote|3028422|3028423|3028424|http://dev.mysql.com/doc/refman/5.7/en/load-data.html|offset|length|3028425|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|0|0|0|0|0|0|1H|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Z|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|10|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|11|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|13|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|14|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|16|8|@]|9|@$P|17|Q|18|1|19]]|A|$]]|$1|R|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]]|S|$T|$5|U|V|W|A|$X|O]]]]

I had the same problem while populating a table in mysql on a AWS instance.

In my case i had the csv file in the instance itself.

Putting the Absolute path solved my problem.

Here's the line from MySQL documentation

<blockquote>
 If LOCAL is specified, the file is read by the client program on the client host and sent to the server. The file can be given as a full path name to specify its exact location. If given as a relative path name, the name is interpreted relative to the directory in which the client program was started.
</blockquote>

<a href="http://dev.mysql.com/doc/refman/5.7/en/load-data.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.7/en/load-data.html</a>

I have looked all over and found no solution, any help on this would be great.

Query:

<pre><code>LOAD DATA INFILE '/Users/name/Desktop/loadIntoDb/loadIntoDB.csv' 
INTO TABLE `tba`.`tbl_name` 
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\r\n'
IGNORE 1 LINES
(
field1, field2, field3
)
</code></pre>

Error:

<pre><code>Can't get stat of '/Users/name/Desktop/loadIntoDb/loadIntoDB.csv' (Errcode:2)
</code></pre>

NOTE:

I'm running MySQL Query browser on OSX 10.6.4 connecting to MySQL 5.x

Things I've tried:

<ul>
<li>Drag-n-drop</li>
<li>Chmod 777</li>
<li>Put in a folder with 777 permissions
as well as the file having 777
permissions</li>
</ul>

mysql load data infile can't get stat of file Errcode: 2

数据库

服务器

MariaDB

MySQL

我已经找遍了，没有找到任何解决方案，任何帮助都是很好的。查询：LOAD DATA INFILE '/Users/name/Desktop/loadIntoDb/loadIntoDB.csv' INTO TABLE `tba`.`tbl_name` FIELDS TERMINATED BY ','LINES TERMIN...

问mysql load data infile无法获取文件状态错误代码:2
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql load data infile无法获取文件状态错误代码:2EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql load data infile无法获取文件状态错误代码:2
EN