I' m reading from this page,
http://www.webmonkey.com/webmonkey/99/21/index2a_page5.html?tw=programming
Further down the page you'll see these examples:
The first thing we need to do is create the actual database. From the command line, type:
mysqladmin -u root create mydb
That creates a database called "mydb." The flag tells MySQL that we're doing this as the root user.
and then:
Copy and paste the following text to a file and save it in MySQL's bin directory. (I'll call the file mydb.dump.)
CREATE TABLE employees ( id tinyint(4) DEFAULT '0' NOT NULL AUTO_INCREMENT, first varchar(20), last varchar(20), address varchar(255), position varchar(50), PRIMARY KEY (id), UNIQUE id (id));INSERT INTO employees VALUES (1,'Bob','Smith','128 Here St, Cityname','Marketing Manager');
INSERT INTO employees VALUES (2,'John','Roberts','45 There St , Townville','Telephonist');
INSERT INTO employees VALUES (3,'Brad','Johnson','1/34 Nowhere Blvd, Snowston','Doorman');
If the lines wrap, make sure that each insert statement is on a new line. Now we'll insert it into the mydb database. From the command line, type:
mysql -u root mydb < mydb.dump
