I am trying to import a text file into mysql but keep getting the same error LOAD DATA LOCAL INFILE '/srv/www/web4/importfile' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' ; error 1148 and when I look this error up I find this: http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html So is this a misconfiguration when installing ISPConfig + extras.... Can anyone help with this. Thanks
what tool do you use to execute this query? if you use mysql from the cli, try use db; source filename; maybe it helps to just allow the option in the my.cnf?
