populating mysql database

Question

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?

Answer 1

Use LOAD DATA INFILE

Answer 2

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