To create the sample MySQL database:
Copy the SQL script file, insert.sql, to an appropriate folder on the computer that has MySQL installed.
If you installed Dreamweaver to its default location, the path to the script file is as follows:

C:\Program Files\Macromedia\Dreamweaver 8\Tutorial_assets\cafe_townsend\data\insert.sql (Windows)
/Applications/Macromedia Dreamweaver 8/Tutorial_assets/cafe_townsend/data/insert.sql (Macintosh)
If the computer running MySQL is a Windows computer, copy the insert.sql script to Program Files\MySQL\MySQL Server 4.x\bin. If the computer running MySQL is a Macintosh, copy the insert.sql script to your Documents folder in your home folder.

On the computer that has MySQL installed, start the MySQL Command Line Client (Windows) or the Terminal (Macintosh).
In Windows, start the MySQL Command Line Client by selecting Start > MySQL > MySQL Server 4.x > MySQL Command Line Client.
On the Macintosh, start the Terminal by going to the Applications folder, opening the Utilities folder, and double-clicking Terminal.
In Windows, enter your username (if any) and password, and then press Enter.
The MySQL client’s command prompt appears, as follows:

mysql>
On the Macintosh, enter the following command:
mysql -uUser -pPassword
For example, if your MySQL user name (also known as an account name) and password are Tara and Telly3, enter the following command:

mysql -uTara -pTelly3
If you don’t have a password, omit the -p argument as follows:

mysql -uTara
If you didn’t define a user name while configuring your MySQL installation, enter root as the user name, as follows:

mysql -uroot
The MySQL client’s command prompt appears, as follows:

mysql>
Create a new database by entering the following command at the MySQL prompt:
mysql>CREATE DATABASE CafeTownsend;
MySQL creates a new database, but it doesn’t contain any tables or records yet.

Log out of the MySQL client by entering the following command at the prompt:
mysql>quit;
(Windows) Open the Windows command prompt by selecting Start > Run, and typing cmd in the Run dialog box.
At the system command prompt, populate the new CafeTownsend database in MySQL.
In Windows, use the following command:

cd \
cd Program Files\MySQL\MySQL Server 4.x\bin
mysql -uUser -pPassword CafeTownsend < insert.sql
On the Macintosh, use the following command:

mysql -uUser -pPassword CafeTownsend < ~/Documents/insert.sql
This command uses the insert.sql file to add tables and records to the CafeTownsend database you created in step 5.