Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

LOAD DATA LOCAL INFILE........

mcgonigle's profile image mcgonigle posted 15 years ago in General Permalink
Hi,

I downloaded HeidiSQL in college to run on the lab machines for my final year project, when i import a csv file with HeidiSQL everything is fine.

Problem is I want to automate this through PHP, but when I use the LOAD DATA LOCAL INFILE command given in HeidiSQL in PHP or directly through the SQL command shell I get an error:
ERROR 1148: The used command is not allowed with this MySQL version

Does anybody know what the problem is?
Is it because HeidiSQL does notshow the full SQL query in the SQL Log and if so how can I find the full query to use in PHP?

Thanks in advance
ansgar's profile image ansgar posted 15 years ago Permalink
You have to run the server with the option "enable-local-infile" if you want to use the LOAD statements:
http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
Code modification/commit from ansgarbecker, 6 years ago, revision 5022
Increase width of shortcut tree, so new translations have enough room. See http://www.heidisql.com/forum.php?t=20009#p20011
Code modification/commit from ansgarbecker, 6 years ago, revision 5024
Fix duplication of query tab controls, when it comes to aligning the query helpers tree. See http://www.heidisql.com/forum.php?t=20041

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.