Running MySQL 4.0.14-nt and trying to upload to phpmyadmin 2.5.6
I exported a CSV from Excel and when uploading I get this error(for data local):
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
If I try the other upload option(data), I get a "permission" type error.
Error
SQL-query :
LOAD DATA INFILE 'C:\\Backup\\dot\\uploadtemp\\php85C.tmp' INTO TABLE `agencies` FIELDS TERMINATED BY '' LINES TERMINATED BY ','
MySQL said:
#1045 - Access denied for user: 'wnyaic@%' (Using password: YES)
Can you point me in the right direction?
I appreciate your help.
bufhal