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 mad

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 gettin

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.