Creating Table in Mysql from a file.sql

[greeneel]

hey guys,

I have a file [filename.sql] and im trying this approach to run the file and have it create a table in mysql and insert some records into it..

mysql -uroot -ppass -h localhost stats_01 < staststypes.sql

and im getting this error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'mysql'

any ideas?

[dagon]

the error is in the staststypes.sql file

[greeneel]

The file.sql basically has data such as this in it...

CREATE TABLE customers (customer_id bigint(20) NOT NULL default '0',
firstname varchar(25) NOT NULL,
lastname varchar(25) NOT NULL,
email varchar(100) NOT NULL,
username char(200) NOT NULL,
password char(200) NOT NULL,
street char(100) NOT NULL,
city char(200) NOT NULL,
PRIMARY KEY (customer_ID)) TYPE=MyISAM;

[bradgrafelman]

Somewhere is the word "mysql" and it doesn't understand what it's supposed to mean. Search the .sql file for this word, or post it here if you can't find the error.