Load Data Local Infile

[GivenRandy]

Does "Load Data Local Infile" not work? I type in the following:

load data local infile "c:\\zip\junkin.txt" into table orders lines terminated by '\r\n' (amount);

And get an error:

File 'c:\zipjunkin.txt' not found (Errcode: 2)

But it does exist and I tried different ways of escaping the "\" and moving file to "c:\", but still no go. Am I doing something wrong?

[jason]

Where are you doing this? From a PHP script or SSH session, perhaps? If so, the script/session can't access your C: drive. You'll need to first upload the file to the server and then run the command. As long as you are running the script from the same directory as the data file (or in the case of SSH, as long as your current directory is the one that the data file is in), you should just need to use the name of the file, not the path (ie load data local infile junkin.txt into table orders...).

Also, if you upload the file in ASCII mode (as you should), the line termination will be \n instead of \r\n.

--Jason