right forum for phpmyadmin advice?
Posted: Thu May 20, 2004 12:57 pm
Hello;
I have saved an Excel file with same fields as MySQL database with a "," at the end of each record(row) and nothing at end of each field. I saved as CSV (not Mac or Dos). Tried to upload to phpmyadmin but get the following error everytime. Do I have the wrong version? MySQL 4.0.14-nt
If I do, what can I do to easily upload these text files?
Thank you
Error
SQL-query :
LOAD DATA LOCAL INFILE 'C:\\Backup\\dot\\uploadtemp\\php673.tmp' INTO TABLE `agencies` FIELDS TERMINATED BY ','
MySQL said:
#1148 - The used command is not allowed with this MySQL version
I have saved an Excel file with same fields as MySQL database with a "," at the end of each record(row) and nothing at end of each field. I saved as CSV (not Mac or Dos). Tried to upload to phpmyadmin but get the following error everytime. Do I have the wrong version? MySQL 4.0.14-nt
If I do, what can I do to easily upload these text files?
Thank you
Error
SQL-query :
LOAD DATA LOCAL INFILE 'C:\\Backup\\dot\\uploadtemp\\php673.tmp' INTO TABLE `agencies` FIELDS TERMINATED BY ','
MySQL said:
#1148 - The used command is not allowed with this MySQL version