Linux 系统下导入数据命令:
load data infile '/var/lib/mysql-files/realVal.csv' into table realVal fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';
报错:
ERROR 29 (HY000): File '/var/lib/mysql-files/realVal.csv' not found (Errcode: 13 - Permission denied)
解决方法:
加“local”,即 load data local infile '~/ils/src/ils_DAP/realVal.csv' into table realVal fields terminated by ',' optionally enclosed by '"' escaped by '"' lines terminated by '\r\n';
此时文件可以在本地中随意位置。
浏览时,看见有些解决方法是修改权限文件内容等方法。