LOAD DATA LOCAL INFILE in C# from memory

Question

Is there a way to use the LOAD DATA LOCAL INFILE command to load data from memory in c#? The closest I can come up with is executing a command like:

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

I'm trying to avoid needing to write a file to the disk (fun with permission issues) on the client's system.

It's a database. How are you going to prevent it from writing to the disk if it wants to? Why would you want to prevent such writing? Are you looking for an in-memory database? — Robert Harvey
– Robert Harvey, Commented Nov 7, 2013 at 16:48
@RobertHarvey The question is not how to prevent the database from writing to disk. The question is how to use LOAD DATA LOCAL INFILE on the client, without the client writing the data to a file first. (This is possible in the Java JDBC driver, I don't know about the .NET driver though.) — nos
– nos, Commented Nov 7, 2013 at 17:02

Mad Dog Tannen · Accepted Answer · 2013-11-07 17:13:31Z

3

No you cant. It must read fom a file on disk. Txt or csv are most common.

http://dev.mysql.com/doc/refman/5.1/en/load-data.html

answered Nov 7, 2013 at 17:13

Mad Dog Tannen

7,2505 gold badges34 silver badges55 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user645280 Over a year ago

How would the server know where the data comes from if you use the --local option? It's all just a stream of bits over TCP/IP either way (since the file isn't on the server). If nothing else, a custom client could follow the protocol but read from memory instead of disk while sending.

Mad Dog Tannen Over a year ago

"The --local option causes mysqlimport to read data files from the client host". The Syntax LOAD DATA INFILE still requiers a txt file to read from. Hence, my answer to the question if its possible to use LOAD DATA INFILE with a memory table as source.

user645280 Over a year ago

There's also a corresponding LOCAL option on the first line when running from in the DB. Does pretty much the same thing regardless of which client you use.

Mad Dog Tannen Over a year ago

@ebyrob, Im sorry im not sure what you mean. I assume you mean the LOAD DATA 'LOCAL' INFILE? But are you saying its not needed to use a file for the load data local infile syntax?

Christopher Stevenson Over a year ago

The official client doesn't support it.

Collectives™ on Stack Overflow

LOAD DATA LOCAL INFILE in C# from memory

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related