how to excute sql text script

[weronpc]

I have a text file contains sql codes, such as create table and insert data into tables.

I installed MySQL on RedHat 9, how do I excute all the sql command in the text file using mysql?

Thank you.

[raf]

what you are talking about is usually refered to as a dumpfile.

you best install a db-frontend, like phpmyadmin or MySQLFront. I prefere the later http://www.mysqlfront.de/
Or pick another one here http://www.mysql.com/portal/software/index.html

or you can use the commandline like running
mysql -h 127.0.0.1 -u root -p < yourfile.sql
(more info http://www.mysql.com/doc/en/Batch_mode.html)