Geek asks and answers

SqlBulkCopy equivalent in MySql?

I'm more used to SQL Server, and I would like to know if in MySql I can find something analogous for SqlBulkCopy. I have a data editor written in WPF / Silverlight and C # using Connector / NET to connect to the MySql server, and I have to provide a function inside the editor to make a full backup of some MySql databases. I do not have direct access to the server, so I can not use dump or other command line tools.

What then is the best way to reset the entire database using only C # code through Connector? I just need to mass export data to XML, CSV, etc. Using your own SQL queries or is there any way to suggest such tasks?

+3
source share
2 answers

SELECT INTO OUTFILE - , . , .

SHOW CREATE TABLE XXXX, sql SELECT * FROM XXXX . Maatkit . , SQL:

http://www.maatkit.org/doc/mk-archiver.html

+1

, MySQL LOAD DATA , . . docs .

OUTFILE ( ), :

SELECT * INTO OUTFILE 'somefile.txt'
FIELDS TERMINATED BY ','
FROM your_table;
+2

More articles: