Re: Load csv file to mysql server

Hi Anonymous Monk...

I'm not set up to test this, but I think your problem here is that you're trying to load a LOCAL file (i.e. on the server) but your file is on your windows box. It would help if you provided the error message, if any.

Solutions could be:

copy the file to the server then use the local loading command,
use Perl to split the file and load the data with INSERTs (could be slow, and error prone...)
or see if you can load from a stream - e.g. STDIN and print the file down the stream to the server. This is what I would do with Postgres, but I don't know MySQL so well.

Hope this helps. You will probably get a better reply, but since no-one has replied and I think I can see the problem at least, I thought I would make my first post on here.

F. V. Shrub

Comment on Re: Load csv file to mysql server

Replies are listed 'Best First'.
Re^2: Load csv file to mysql server by Anonymous Monk on Jul 27, 2009 at 12:50 UTC
how i can load my file from windows with out copying the file to my sql server.	[reply]
Re^3: Load csv file to mysql server by FalseVinylShrub (Chaplain) on Jul 27, 2009 at 14:45 UTC
Hi Sorry, I don't know the answer beyond the general approaches that I mentioned in my post. Someone who knows mysql better than me will have to answer. If you don't get answers on here, try searching some mysql sites for how to load a remote file, or how to load from STDIN. hth. F.V.S.	[reply]