Mysql: the Definitive Guide to Using, Programming, and Administering Mysql 4.1 and 5.0

Obtaining the sampdb Sample Database Distribution

The sampdb distribution contains the files that are used to set up and access the sampdb sample database. It is available at the following address:

http://www.kitebird.com/mysql-book/

The sampdb distribution is available as either a compressed tar file or as a Zip file. To unpack a distribution in tar format, use one of these commands (use the second command if your version of tar doesn't understand the z option):

% tar zxf sampdb.tar.gz % gunzip < sampdb.tar.gz | tar xf -

To unpack a Zip-format distribution, use a utility such as WinZip, pkunzip, or unzip.

When you unpack the distribution, it will create a directory named sampdb containing several files and subdirectories:

• A README.txt file containing additional general instructions for using the distribution. This is the first file you should look at. Individual subdirectories of the distribution may also contain a README.txt file with more information.

• Files for creating and loading the sampdb database. These are used in Chapter 1, "Getting Started with MySQL and SQL."

• A capi directory containing the C programs used in Chapter 6, "Writing MySQL Programs Using C."

• A perlapi directory containing the Perl DBI scripts used in Chapter 7, "Writing MySQL Programs Using Perl DBI."

• A phpapi directory containing the PHP scripts used in Chapter 8, "Writing MySQL Programs Using PHP."

• An ssl directory containing certificate and key files for setting up SSL connections between MySQL client programs and the server.

The sampdb directory also includes a few other directories containing files that are referenced at various other points in this book. Check the README.txt file for further information.