import data to mysql tables

[aarbar201059]

I get error #1148 "The used command is not allowed with this mysql version" when trying to use:

'load data local infile' to upload data to a table in my database. I'm using the format CSV using LOAD DATA and check the use local keyword, plus using appropriate field terminated, enclosed, escaped, data.

The error doesn't make sense since the import tab even includes it.

 

[garrettroyce]

I believe you have to use the import tool directly. PHPMyAdmin queries the database with the contents of the file, it doesn't use the infile command.