in reply to 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:

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

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.

      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.