MySQL Query, bulk insertion

Question

I have a bulk data for insertion in MYSQL Tables, let use suppose, 10k in one time, What I am doing is store the data in an XML file and then go for insertion (data is around 50K rows), It will take a lot of time, Is there any option for bulk insertion in MySQL tables.

Thanks in advance,
Please help.

Learning · Accepted Answer · 2009-03-23 06:32:23Z

3

LOAD DATA INFILE can help. It is the fastest way to load data from text file.

answered Mar 23, 2009 at 6:32

Learning

8,2133 gold badges39 silver badges47 bronze badges

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

2 Comments

Ashok Over a year ago

Is it possible If I Have a XML File, Can I use make bulk insert in MYSQL on basis of XML file data, If yes, ?Can you Explain .. Thanks

Learning Over a year ago

XML cannot be inserted directly. But there are many (free) off the shelf utilities that will convert the xml data to flat data. That can be your starting point.

Cesar · Accepted Answer · 2009-03-23 15:27:35Z

0

You may also want to disable de indexes before insertion and enable them afterwards to recreate them.

ALTER TABLE ... DISABLE
ALTER TABLE ... ENABLE KEYS

edited Mar 23, 2009 at 15:27

answered Mar 23, 2009 at 6:34

Cesar

1,6112 gold badges16 silver badges42 bronze badges

2 Comments

Ashok Over a year ago

Is there any way to Bulk insertion of Data from Collection to Mysql Database.

Cesar Over a year ago

What do you mean with Collection?

Collectives™ on Stack Overflow

MySQL Query, bulk insertion

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related