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.