From mysql console
mysql>source [file_path]
From command line:
shell>mysql -u [user_name] -p[password] -h [host] -- verbose < [file_path]
notes:
"--verbose" is required to display the sql statements before it is executed
make sure to add "use [database_name]" statement in the script file
Reference:
http://dev.mysql.com/doc/refman/5.0/en/batch-commands.html
