Creating the Database
In this section, you will create and fill the database with the initial data load. You will put all the statements except the create database into a file, which you can use to reload the database later if necessary.
Listing 6.1 assumes that a MySQL server is installed and running on the target machine.
First, start the MySQL command line tool by typing this line:
This changes the prompt to mysql>.
Then create the database:
mysql> CREATE DATABASE sesi;
Usage (from the command prompt):
%mysql < listing.6.1
%mysql -t < listing.6.1
The -t option sends ...