Posted by Justin on 06/09/06 04:10

thanx. i fixed the problem eventually... there was an mysql error code
2 i think. it couldn read the csv file at first... so i uploaded the
csv file into the ftp and tried for a few times and it was done... i
think i was lucky though... so wat's the diff between load data local
infile and load data infile??

Ivan Marsh wrote:
> On Wed, 07 Jun 2006 02:20:19 -0700, Justin wrote:
>
> > Hi, im facing a problem here. First of all here is my program
> > requirement. I got a .csv file with thousands of records inside, i need
> > to import them into my mysql database. So i tried using load data infile
> > on my pc using localhost everything goes fine, but when i change the
> > connection to my server, it seems tat the connection cant be done... so
> > wat went wrong?
>
> Could be any number of things from a network issue to a database
> permissions issue. Are you getting any specific error message?
>
> --
> The USA Patriot Act is the most unpatriotic act in American history.
> Feingold-Obama '08 - Because the Constitution isn't history,
> It's the law.

[Back to original message]