Load Data Infile

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
tony lehtola

Load Data Infile

Post by tony lehtola » Thu 20 Jan 2005 16:06

I am having a problem with the load data MySql command. I can run queries successfully with the load data infile command, but the moment I try to use the LOCAL argument, I get the method not supported message. Is the local arguement not accepted through MySqlDirect, and if not, is there another way I can achieve the same functionality without resorting to mapping a drive and copying the source?

LOAD DATA LOCAL INFILE 'C:/perfsource.txt' into table performer_ins;

Error: CoreLab.MySql Specified method is not supported.


Devart Team
Posts: 264
Joined: Thu 28 Oct 2004 13:56

Re: Load Data Infile

Post by Oleg » Fri 21 Jan 2005 09:14

Now we don't support LOAD DATA LOCAL INFILE in Direct mode.
To use this command add Direct = false to your connection string.

Post Reply