mysql|mysql ERROR 29 (HY000): File \'xxx.txt\' not found& mysqlERROR29(HY000):File\'xxx.txt\'n

早2天重新装了系统，用的是ubuntu的，安装了mysql数据库
今天想把一个csv文件里面的数据导入到mysql里面去，但是一直导入不进去，报的错误是

ERROR 29 (HY000): File \'xxx.txt\' not found (Errcode: 13)

开始我以为是我写法有问题，语句如下

LOAD DATA INFILE '/home/cullen/area.csv'INTO TABLE AreaCHARACTER SET utf8FIELDS TERMINATED BY ',' ENCLOSED BY '"' ;

然后在网上找了一堆资料，在前面的基础上面加了个local

LOAD DATALOCAL INFILE '/home/cullen/area.csv'INTO TABLE AreaCHARACTER SET utf8FIELDS TERMINATED BY ',' ENCLOSED BY '"' ;

这个时候报错更加离谱了说是什么输入的命令不适用我现在使用的mysql版本

ERROR 1148 (42000): The used command is not allowed with this MySQL version

然后我就去其他的网站找解决办法

That's the same thing for me.However using LOCAL isn't a solution, it's just a bypass.The problem can be resolved by configuring AppArmor, see this thread : http://stackoverflow.com/questions/2...t-into-outfile, or directly :Code:sudo vi /etc/apparmor.d/usr.sbin.mysqld/usr/sbin/mysqld {.../var/log/mysql/ r,/var/log/mysql/* rw,/var/run/mysqld/mysqld.pid w,/var/run/mysqld/mysqld.sock w,/data/ r,/data/* rw,}Code:# sudo /etc/init.d/apparmor reload

上面是解决办法大意是用su的权限修改 /etc/apparmor.d/usr.sbin.mysqld这个文件
在文件里面加入红粗体字的内容