php - Loading CSV File into MySQL returns error -
i trying load csv file database table.. absolutely 100% sure file path correct , have verified 1 hundred times. despite this, when run sql query, tells me file path wrong.
is file path requesting special in case? assume use root pathing..
load data local infile '/var/www/html/wordpress/cron/members.csv' table members_copy fields terminated ',' enclosed '"' lines terminated '\n';
i'm thinking perms issue. check perms on every directory root file...making sure have executable rights in directories (/var, /var/www, /var/www/html, etc ). i'm assuming file @ least 644.
Comments
Post a Comment