Re: LOAD DATA command not working - Keno - com.mysql.lists.win32

4 messages in com.mysql.lists.win32Re: LOAD DATA command not working

From	Sent On	Attachments
Keno	02 Jul 2002 21:01
Mignon Hunter	03 Jul 2002 07:40
Keno	03 Jul 2002 17:17
Mignon Hunter	03 Jul 2002 18:10

Subject:	Re: LOAD DATA command not working
From:	Keno (ke...@coretechnologies.com)
Date:	07/03/2002 05:17:48 PM
List:	com.mysql.lists.win32

That works dude :)

I have 98 but had the same error. If you are trying:

mysql> LOAD DATA LOCAL INFILE "data.txt" INTO TABLE tablename;

Try instead:

mysql> LOAD DATA INFILE "data.txt" INTO TABLE tablename;

And I believe my txt file was in the mysql\data directory.

To run other scripts, the files have to be in the bin directory, and then type:

mysql> source file.txt;

-----Original Message----- From: Keno [mailto:ke...@coretechnologies.com] Sent: Tuesday, July 02, 2002 11:01 PM To: win...@lists.mysql.com Subject: LOAD DATA command not working

Hi all,

Just installed Mysql 3.23.51 and use the mysqld-max-nt service. Created db, tables. Now I want to load some data from an external file but I'm getting an error claiming that the load data command is not working with the version of mysql. Any ideas??