#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    Hi,
    I am having trouble with this command. I am using win 98, connecting through telnet to my isp.
    I have tried a number of things:
    1) tried to load data with phpmyadmin
    2) tried manually loading through telnet:

    LOAD DATA INFILE '/home/afp/brandmodel.txt' INTO TABLE brandmodel
    FIELDS TERMINATED BY ',' ENCLOSED BY '"'
    LINES TERMINATED BY 'r';
    (also tried 'n')

    I get the error on both:
    ERROR 1045: Access denied for user: 'afp@localhost' (Using password: YES)

    BTW: I did set file permissions of file to 777. I also tried manually inserting one entry through phpMyAdmin and it worked.

    I believe my syntax is correct, so I think it is either the file and table, or my priviledges maybe?

    I have asked my ISP about priviledges, and he is going to look into it.
    So I will explain the table and the text file.
    Table: 14 fields, all var char(255), Null.
    text file: made with ms access comma seperated, enclosed by ". One thing I did notice when looking at the text file is that the entries that were empty on access do not have quotes, there are just commas.

    I've tried so many things.. can someone please help me to get this working? I may be missing something fundemental, or something I did wrong initially. Thanks for any and all help on this.

    Dave
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    19
    I'm not sure what's wrong there, but I can tell you this: That error is a mysql permissions error. Has nothing to do with file permissions or the integrity or format of the file.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    ok, thats great, at least I'm not doing anything wrong

Similar Threads

  1. Replies: 0
    Last Post: February 11th, 2004, 03:56 PM
  2. Newbie trying to load data file
    By wab25 in forum Flash Help
    Replies: 2
    Last Post: February 6th, 2004, 05:21 PM
  3. how to load data from excel into C++ Application
    By lenochka in forum C Programming
    Replies: 5
    Last Post: July 10th, 2003, 09:08 AM
  4. load data infile & NOW()
    By saraht28 in forum MySQL Help
    Replies: 0
    Last Post: May 7th, 2003, 07:17 AM
  5. Load data infile and null values
    By joebw in forum MySQL Help
    Replies: 4
    Last Post: February 1st, 2003, 12:22 PM

IMN logo majestic logo threadwatch logo seochat tools logo