inserting 50,000 rows of data into a table

Hi,

anyone have any tips on inserting 50,000 rows of data into a table?

i have 50,000 + listings that need to be imported into a table.

is there a quick way to do this?

can i use this:

mysqldump databasename tablename > file.sql to do this?

if so, what would the file.sql look like?

something like:

INSERT INTO table VALUES (

"1", "John Smith" "2 Breeze ave";
"2", "John Doe" "1 main st.";

);

thanks for your help,

I would suggest using "LOAD DATA". Here is a link to the section on this command in the manual -

Hope this helps 😉

i have done this before.

this exports it: mysqldump --opt -p tablename > tablename.sql

this imports it: mysql -p tablename < tablename.sql

(the -p is just to make it ask for your password)

btw, you were right, it does show up like INSERT INTO blah...

its just a big comma dilemited text file