Re: LOAD command

2002-10-01 Thread gerald_clark
The SERVER needs to be able to read the file, and I doubt very much that mysql has read permissions here. Jim Bahr wrote: Hello I am trying to use the LOAD command and not having much success. My host company is using version mysql 3.23.51. I am sshing into server, starting mysql and getting

re: LOAD command

2002-10-01 Thread Egor Egorov
Jim, Tuesday, October 01, 2002, 4:01:18 PM, you wrote: JB I am trying to use the LOAD command and not having much success. My host JB company is using version mysql 3.23.51. I am sshing into server, JB starting mysql and getting a mysql prompt. I have a database called JB login, and have made

Re: LOAD command failed if the Local infile is not \bin

2001-12-13 Thread Paul DuBois
On Thu, Dec 13, 2001 at 12:34:59PM -0500, [EMAIL PROTECTED] wrote: Hi, I just discovered that I have to move the data text file I want to store in my table into bin directory of mysql directory (c:\mysql\bin\) before the LOAD DATA local infile text.txt INTO TABLE tabname can work. No