Bringing the tables of one mysql to another

[Taizong]

Say I login to my web server and am at the mySql prompt:

mysql>

How would I bring in the tables of a sql file in say /var/junk/blah.sql to my current open mysql file?

[jcrowe]

how bout mysql < blah.sql

you may have to fit in the database name in there somewhere.

[EscapeCharacter]

log into mysql then type "\. /path/to/sqlfile" that will execute the all the queries in that file