Cant use LOAD DATA INFILE

[rondog]

I have a CVS file with 2000+ entries that I need to input. I tried:

LOAD DATA INFILE 'http://www.website.com/store.csv'
INTO TABLE ssp_dealers
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(customer, street1, street2, city, state, zip);

 

but it says access denied.

 

I tried

LOAD DATA LOCAL INFILE 'http://www.website.com/store.csv'
INTO TABLE ssp_dealers
FIELDS TERMINATED BY ','
LINES TERMINATED BY '\n'
(customer, street1, street2, city, state, zip);

 

and it says it cant find it...I dont have access to the server so I cant use the second example and LOAD DATA LOCAL INFILE and it appears my privelages for LOAD DATA INFILE are restricted. Any ideas of doing this..maybe a php script?

[cunoodle2]

Do you have phpmyadmin?  Cause there is a utility to upload directly from a csv file.  I've used it with great success numerous times in the past.

[rondog]

I dont have it on the server I am working on, but I have it on another. Essentially what I can do is import it to the server that has phpMyAdmin and then export an SQL file. Now I tried using the import tool and it spit back an error:

 

at the top:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 121997
STR: '

 

then all my information..scroll down and the following error says:

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Denali Cigars,2026 McCullam,,Fairbanks,AK,99701
Lucky Raven,36312 Irons Avenue,' at line 1 

 

What happens when this succeeds? It didnt even ask what table I wanted to put it in?

[rondog]

anyone know??

[rondog]

I really need some help and cant find a solution. Never done this before and could use a little direction

[mainewoods]

an sql engine tries to 'compile' the entire sql statement before it executes any of it so if it finds a parse error it will fail right there. I suspect your problem is that one of the fields you are trying to export has a single quote character in it that did not get escaped somewhere's along the line and then therefore is 'breaking' the sql which uses single quotes as part of the syntax.

 

open up the sql file and copy the part around the error to this board and we'll look at it.