SQL Dump back into new database

[rgermain]

Hey,
If I have a txt file that is comma delimited file of a database dump how would I get that back into a new database?

I haven't done this forever and any help would be great thanx a ton.

[Wynder]

It's going to depend..

From the command line:

mysqlimport --debug[1] -u username -p --fields-terminated-by "," --lines-terminated-by="\n\r" dbname tablename.txt

The filename is the tablename. Gotta figure out how your lines are terminated... with some Windows files it's \r\n.. g'luck.