Execute SQL script (MySQL dump) from command line

1) Find you mysql installation directory:

uki: ~ $ cd /usr/local/mysql/bin

2) Start mysql shell

uki: ~ $ ./mysql -u root

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 238

Server version: 5.5.9 MySQL Community Server (GPL)

...

3) Select database you want to execute script agaist

mysql> use my_database_name

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

4) Execute SQL script
in the next line notice "slash dot space"

mysql> \. /Users/uki/Documents/script_name.sql