Error Code : 13 Can‘t get stat of ‘/httpdocs/.../.../testFile.csv‘ (Errcode: 2)

Error Code : 13 Can't get stat of '/httpdocs/.../.../testFile.csv' (Errcode: 2)

 1, LOAD DATA INFILE  修改为LOAD DATA local INFILE，我用shell脚本这样解决了。

oad_data_sql="LOAD DATA local INFILE '$folder_path/$file' INTO TABLE $table_name FIELDS TERMINATED BY '|+#|' ENCLOSED BY '\"' LINES TERMINATED BY '\r\n';"

  mysql -u $MYSQL_USER -p$MYSQL_PASSWORD -e "$load_data_sql"

2，mysql cli 添加--local-infile=1；在cli里面执行是可以。