I just ran into this issue as well. I had to add LOCAL to my SQL statement. For example, this gives the permission problem: LOAD DATA INFILE ‘{$file}’ INTO TABLE {$table} Add LOCAL to your statement and the permissions issue should go away. Like so: LOAD DATA LOCAL INFILE ‘{$file}’ INTO TABLE {$table}
You can use the LOAD DATA INFILE command to import a CSV file into a table. Check the link MySQL – LOAD DATA INFILE. LOAD DATA LOCAL INFILE ‘abc.csv’ INTO TABLE abc FIELDS TERMINATED BY ‘,’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\r\n’ IGNORE 1 LINES (col1, col2, col3, col4, col5…); For MySQL 8.0 users: … Read more
This will do what you want. It reads the fourth field into a local variable, and then sets the actual field value to NULL, if the local variable ends up containing an empty string: LOAD DATA INFILE ‘/tmp/testdata.txt’ INTO TABLE moo FIELDS TERMINATED BY “,” LINES TERMINATED BY “\n” (one, two, three, @vfour, five) SET … Read more
Use mysqlimport to load a table into the database: mysqlimport –ignore-lines=1 \ –fields-terminated-by=, \ –local -u root \ -p Database \ TableName.csv I found it at http://chriseiffel.com/everything-linux/how-to-import-a-large-csv-file-to-mysql/ To make the delimiter a tab, use –fields-terminated-by=’\t’