How to run .sql file from mysql > on linux

[hongmei]

Hi,

I have the following questions about mySQL:

I have a sql file which can automatically create database tables for me. But I need to know how to run my .sql file at the mysql>
on linux system. Could anyone tell me which command should I issue. supposed that my createtable.sql file is located at /home/hlu/ directory

Thanks

hongmei

[ahundiak]

From the linux prompt
mysql -s -u user -p databasename
password
mysql>source createtable.sql

[hongmei]

Thanks! It worked!

hongmei