?
Solved

MysqlBulk upload for a datatable

Posted on 2017-06-18
3
Medium Priority
?
52 Views
Last Modified: 2017-07-04
Hi

I have a datatable and want that datatable to upload in a table in mysql. I have used bulkupload in sql, need to know how we can do the same using MySqlBulkLoader.

I dont want to give each and every column name of the table while upload and neither want to convert the datatable to cvs format.

Is there a way i can directly bulk upload using mysql from datatable directly?
0
Comment
Question by:baishali deb
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 79

Assisted Solution

by:arnold
arnold earned 1000 total points
ID: 42183190
Not sure what you have, mysqldump might be what you are looking for to backup a table from a database.
You could then restore the data from table into ...

To your question example for usage
https://dev.mysql.com/doc/connector-net/en/connector-net-programming-bulk-loader.html
0
 
LVL 27

Accepted Solution

by:
Zberteoc earned 1000 total points
ID: 42183857
If you intend to import data from flat files inside MySQL then the LOAD statement is the way to go:

https://dev.mysql.com/doc/refman/5.7/en/load-data.html
0
 
LVL 79

Expert Comment

by:arnold
ID: 42183863
Mysqlbulkload is an interface to load data Infile for a .net app......
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this article, I’ll talk about multi-threaded slave statistics printed in MySQL error log file.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question