Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004

    Unanswered: Running into two errors

    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):
    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.

    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.

  2. #2
    Join Date
    Jan 2003
    Paris, France
    It seem that you do not have the privilege file on your server

    check that
    Olivier Miossec

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts