I was using the code
LOAD DATA LOCAL INFILE "my text file path" INTO TABLE "tablename" FIELDS TERMINATED BY '\t'
and it was working fine... but now I get the error :-
the used command is not allowed in this version of mysql
I read that you get that error when someone disables all LOAD DATA LOCAL commands in the MySQL server.
The people who look after the server said they didn't do anything.What can I do?
If I try using .. INFILE "http://fullpath"
it gives me the error :-
can't get stat of http://...
Can someone help me.
Thanks Di
Can I use mysqlimport in my php? Or is that strictly at the command prompt.