求助 mysql 用 load data infile 批量导入数据 存在的问题

Web、Mail、Ftp、DNS、Proxy、VPN、Samba、LDAP 等基础网络服务
回复
why930908
帖子: 11
注册时间: 2016-04-03 10:55
系统: Ubuntu

求助 mysql 用 load data infile 批量导入数据 存在的问题

#1

帖子 why930908 » 2016-04-12 13:04

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)

求助 明明文件存在 而且也有访问权限 但是 就是显示文件不存在。。 求大神告知我的问题
回复