populating DB with million entries

Question

I want to populate MySQL database with million entries,

I tried using Data generator, but i was able to get only 200 entries though i give 1000 as input, which takes a lot of time for populating.

Also tried using .txt file LOAD FILE LOCAL INFILE method for populating, but get an error as FILE NOT FOUND though the file exists in my local directory (ERRCODE: 2 & ERRCODE: 22).

I was thinking is there any better way for populating DB with million entries for performance and if so can somebody suggest me with ideas resolving my query?????

how to populate my db with million values????

score 2 · Accepted Answer · edited Nov 29 '12 at 21:45

2

Try data generator. It allows you to generate precisely the data you want (you can choose columns, etc...).

edited Nov 29 '12 at 21:45

Synxis

9,236
2
42
64

answered Nov 29 '12 at 21:23

1054211

442
2
6

I tried using data generator but it gives me max of 200 rows though i give 1000 rows as input..!!!! – Mounica Nov 29 '12 at 22:52
The source code is available for you to use and remove the limit. The sample web app you were using limits to 200rows as to avoid being overloaded by multiple people trying to generate millions of records. Download the source code from the Download tab, remove the limit and enjoy. – 1054211 Nov 30 '12 at 16:09

score 1 · Answer 2 · edited May 23 '17 at 11:43

1

Check out generate-dummy-test-data-for-mysql-using-routines or generating-dummy-data-for-my-web-application-looking-for-dictionaries

edited May 23 '17 at 11:43

Community

1
1

answered Nov 29 '12 at 21:47

Avner Levy

6,601
9
53
92

populating DB with million entries

2 Answers2