SEO

#1 (**permalink**) 02-28-2008, 07:52 AM

Hello ng,

I'm trying to do this mysql query but I receive an error. Can someone help
me?

LOAD DATA INFILE
'ftp://USER%40WEBSITE.COM:PASSWORD@ftp.WEBSITE.COM/FILE.csv' REPLACE INTO
TABLE mytable FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1
LINES

FILE.csv is on another server into a protected folder that needs user and
password.
I receive this error: Error 1045 : Access denied for user 'xxx'@'%' (using
password: YES)

Notice that the user xxx in the error is different from the user of ftp link
and it is the same of user I use to connect to my database.
I'm thinking I have to give some permission to xxx user but I don't know on
which server and how I can do that!

Anyone has some suggestions? Thank you!

Luca

#2 (**permalink**) 02-28-2008, 07:52 AM

ok! I give privileges to xx with phpmyadmin!

But now I receive

Error 13 : Can't get stat of
'ftp://USER%40WEBSITE.COM:PASSWORD@ftp.WEBSITE.COM/FILE.csv' (Errcode: 2)

(

Any help?

"Luca" <kazzarola@hotmail.com> ha scritto nel messaggio
news:1e8pg.4640$yg6.3754@tornado.fastwebnet.it...
> Hello ng,
>
> I'm trying to do this mysql query but I receive an error. Can someone help
> me?
>
> LOAD DATA INFILE
> 'ftp://USER%40WEBSITE.COM:PASSWORD@ftp.WEBSITE.COM/FILE.csv' REPLACE INTO
> TABLE mytable FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' IGNORE 1
> LINES
>
> FILE.csv is on another server into a protected folder that needs user and
> password.
> I receive this error: Error 1045 : Access denied for user 'xxx'@'%' (using
> password: YES)
>
> Notice that the user xxx in the error is different from the user of ftp
> link and it is the same of user I use to connect to my database.
> I'm thinking I have to give some permission to xxx user but I don't know
> on which server and how I can do that!
>
> Anyone has some suggestions? Thank you!
>
> Luca
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode