求助 mysql 用 load data infile 批量导入数据 存在的问题
发表于 ： 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)
求助 明明文件存在 而且也有访问权限 但是 就是显示文件不存在。。 求大神告知我的问题
-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)
求助 明明文件存在 而且也有访问权限 但是 就是显示文件不存在。。 求大神告知我的问题