How do I import sql from a CD?

[Guest_imported]

Hi, I am currently learning php and mysql from a book, (PHP and MySql web development) All the code comes on a cd, I am in the MySql tutorials and they say I can use the sql from the cd instead of typing it all in by hand, but I'm not sure how to do this, any suggestions?

 

[gheist]

You mount CD in your CD reader and look for different files containing SQL statements -

 

[Guest_imported]

Yeah and then how do I open it so it can be incorporated into Mysql?

 

[gheist]

cat file.sql | mysql

 

[KarveR]

at the mysql prompt :
mysql> \./path/to/file/file.sql

and the sql will be run. ***************************************
Party on, dudes!