10K + Row Insert

[Tracer]

I have an approximately 10,000 Plus records (each record = 1 row) that I need to INSERT into a REMOTE (TCP) mysql database... using a While loop obviously takes way to long... Any other suggestions?
Can I create a single Mysql command with 10,000 inserts in it?

[stolzyboy]

is this a one time thing or will this need to happen often?

if its a one time thing, do a mysqldump or use something like phpMyAdmin to export an .sql file and then import the .sql file into the new db