List:General Discussion« Previous MessageNext Message »
From:Richard Whitney Date:January 4 2005 6:16pm
Subject:Load data infile...
View as plain text  
I think I'm bringing this up again but with different errors.

This:   		$sql = "LOAD DATA INFILE '$file' REPLACE INTO TABLE `jobs` FIELDS
TERMINATED BY '\\t' OPTIONALLY ENCLOSED BY '\"' ESCAPED BY '\\\\' LINES
TERMINATED BY '\\r\\n'";

is getting the error "Access denied for user: 'user@%' (Using password: YES"

I have no idea where the % sign is coming from. shouldn't it say user@loclhost
like it's setup in the db connection script?

Any clues?  Thanks!

R. Whitney
Transcend Development
"Producing the next phase of your internet presence"
http://xend.net
Premium Quality Web Hosting
http://xendhosting.com
rw AT xend.net
Net Binder  http://netbinder.net
310-943-6498
602-288-5340

Thread
Load data infile...Richard Whitney4 Jan
  • Re: Load data infile...Gleb Paharenko5 Jan
RE: Load data infile...Tom Molesworth5 Jan