Yes, LOCAL is when client and server are on different boxes and the file is LOCAL to the client. You don't need that keyword otherwise.
Regards, Bhavin. ----- Original Message ----- From: "David Sammons" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 08, 2002 10:20 AM Subject: RE: problems enabling local-infile > I've got it. I was using the LOCAL attribute in my LOAD DATA command and it > wouldn't work. After getting rid of LOCAL, it works. > > ds > > -----Original Message----- > From: David Sammons [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 11:03 AM > To: [EMAIL PROTECTED] > Subject: RE: problems enabling local-infile > > > Yes, I've checked the manual and have tried several applicable commands. > I'm running both the server and client on this pc. > > I've tried: > > \mysql\bin> mysql --enable-local-infile; [unrecognized option error] > \mysql\bin> mysql --local-infile=1; [no error, but LOAD DATA LOCAL INFILE > command not enabled] > > I'm just testing to use this command to populate some tables. For testing > purposes I've created a simple table (3 fields: field1, field2, field3) and > a simple text file with 3 tab-delimited records. Help?! > > ds > > -----Original Message----- > From: DL Neil [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 08, 2002 10:47 AM > To: David Sammons; [EMAIL PROTECTED] > Subject: Re: problems enabling local-infile > > > Hi David, > > > Help?! I'm new to mySQL and am having a heck of a time enabling > > local-infile to populate a table. I'm running v3.23.51 on win200pro. Any > > ideas? > > > > I've tried several different command-line options with no luck. Help?! > > > So you've checked the manual and performed whatever is necessary > version-wise. > Is the Win2000 running both server and client, or are there two physical > machines here? > > Please post your current command, and the errmsg received. > > I have 3.23.51-nt too. If it is not sensitive, and also post the > schema/CREATE TABLE and a few data records, I'll try it here for you. > > Regards, > =dn > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php