LOAD DATA INFILE problem?

[iceman2g]

I'm trying to load info from a txt file into table in my db.

I'm trying using this to do it.

$sql = mysql_query("LOAD DATA LOCAL INFILE 'C:\\apache\\htdocs\\fah\\daily_user_summary.txt' REPLACE INTO TABLE users IGNORE 2 LINES");
		if (!$sql) { echo mysql_error(); }

I'm getting this error though.

The used command is not allowed with this MySQL version

Any help would be greatly appreciated.

[Mibble]

i had the same problem, am using apache2, php 4.3.9 and mysql 4 however using the mysqlimport that works fine . . . which is almost the same as load infile

[iceman2g]

Not familiar with mysqlimport what all was involved in getting it to work?

[Mibble]

not much at all, go to mysql.com and search for mysqlimport

[iceman2g]

thank you🙂