I'm just moving a little DB from my home server to a remote one, so I've dumped all db info into a .sql file.

Now how do I get it into the database on the new server?

I've tried tinkering with the mysqlimport shell command, but I require a password to get into the mysql shell. It wigs out when I try mysqlimport, saying I don't have permission. SO, instead, I've tried using the "LOAD DATA INFILE '...'" statement, but it claims I've got a syntax error.

Anyone know a quick solution? I simply want to recreate my database from the file... (And the DB DOES already exist)

Thanks!