CODEWITHSUNDEEP
mysqllarge-files
Grumpy
Grumpy

Reputation: 2243

populating mysql database

I have a file with over a million lines of data, each line is a record.

I can go through the file, read the line and do a insert, but this can take up to 2 hours. Is there a faster way like uploading a sql file?

Upvotes: 1

Views: 168

Answers (2)

zapping
zapping

Reputation: 4116

You can use Find and replace to build an insert statement around it.

Upvotes: 0

Quassnoi
Quassnoi

Reputation: 425251

Use LOAD DATA INFILE

Upvotes: 1

Related Questions