Microsoft Word - Sam's Teach Yourself MySQL in 21 Days - SAMS.doc

Installing from the CD-ROM

Note The following instructions are specific to Linux.

If you choose to use the distribution that is available on the CD-ROM, you will have to do a manual

install. To do that, perform the following steps:

1. First, you will need to mount the CD-ROM. Refer to your operating system's user
   manual to do this.


2. After you have the CD-ROM mounted, you will need to copy the file to a directory
   on your system. From the command line, type the following:


3. %> cp DBI-1.11.tar.gz /home/mark/DBI-1.11.tar.gz

Use a directory to which you have access. Generally, your home directory is a good

choice.

4. After you have copied the file, change directories to that directory if you are not
   there already.


5. %> cd /home/mark


6. The next step is to unzip the file. To do this, type the following from the command
   line:


7. %> gunzip DBI-1.11.tar.gz


8. %> tar –xvf DBI-1.11.tar


9. After the files have been extracted properly, you are ready to compile them. To do
   this, change to the newly created DBI-1.11 directory by typing the following:


10. %> cd DBI-1.11


11. The next step is to create the make file. To do this, type the following:


12. %> perl Makefile.pl

A lot of data will flash across the screen, providing you with progress notes. Upon

completion, you will be notified if the file was successfully created. If it was, you can

continue with the installation.

13. The next step is to actually add the module to the correct directories. To do this,
    type the following:


14. %> make

A lot of data will again fly across the screen. When this is done, type the following

command:

%> make test

Again you will see a lot of flying data. After it finishes, type the following command:

%> make install

After this successfully finishes, you will have installed the Perl DBI.

Installing the MySQL DBD

The next step is to install the MySQL DBD. This driver can be found at CPAN or the MySQL Web site. For
your convenience, it has been added to the CD-ROM as well. To install the DBD, perform the following
steps:

1. Mount the CD-ROM drive if you haven't already. Follow your operating system's
   user guide to accomplish this.


2. Copy the MySQL driver to a directory you can access. The filename for the driver
   is Msql-Mysql-modules-1.2209.tar.gz.


3. After you have copied the file, unzip it as you did the DBI using the same
   commands—just change the filename.


4. After you have unzipped your file, enter the following command at the command
   line:


5. %> perl Makefile.PL

You should be prompted with the following choices:

1. MySQL only


2. mSQL only (either of mSQL 1 or mSQL 2)