Executing SQL Statements from a Sql File

Use the follwoing command:

mysql> source file_name
or
mysql> \. exact_path_file_name

for an example:

mysql> \. /tmp/Marbil/marbil.sql

for further reading go to :
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html