Forum Moderators: open
I have got a typical problem in inserting Bulk Data from a .csv or .txt file into MySQL.
The code I wrote is:
$sql="LOAD DATA INFILE '".$filepath."' INTO TABLE att_temp FIELDS TERMINATED BY '\t' ENCLOSED BY '\"' LINES TERMINATED BY '\n'";
mysql_query($sql);
Its working fine in my local system. But when I run this code on the remote server it fails. I have got all the administrative permission on the DB.
Can anyone help?
Thanks in advance
[dev.mysql.com...]
Don't forget to FLUSH PRIVILEGES after making permission updates.