root@ubuntu:/tmp# ll 112.txt
-rwxrwxrwx 1 root root 84 Apr 12 13:02 112.txt*
root@ubuntu:/tmp# more 112.txt
00005,"11","er","e","ewre","erwer",21,143
00006,"11","er","e","ewre","erwer",21,143
mysql> load data infile '/tmp/112.txt' into table pbminfo fields terminated by ',' enclosed by '"';
ERROR 29 (HY000): File '/tmp/112.txt' not found (Errcode: 13)
求助 明明文件存在 而且也有访问权限 但是 就是显示文件不存在。。 求大神告知我的问题
求助 mysql 用 load data infile 批量导入数据 存在的问题
-
- 帖子: 11
- 注册时间: 2016-04-03 10:55
- 系统: Ubuntu
- staunch
- 帖子: 255
- 注册时间: 2008-07-28 19:29
Re: 求助 mysql 用 load data infile 批量导入数据 存在的问题
你那个txt文件权限不够,你用ls -l /tmp看一下,权限不对用chmod 777 ./112.txt