Installing MySQL and related Perl modules locally.

This document explains how to install their own working copy of MySQL (on a UNIX machine). The MySQL manual states that the following drivers are needed to support PERL. (You will need a gcc or other ``C compiler'' before attempting these installations) Data-Dumper-2.101 DBI/DBI-1.13.tar.gz Data/Data-ShowTable-3.3.tar.gz DBD/Msql-Mysql-modules-1.2217.tar.gz I installed them as follows: (The MySQL manual indicated that order is important.) The following archives are required (version numbers may have changed, these are the ones I used):

a. If your platform has a C compiler AND is supported by xsubpp:

gzip -c -d Data-Dumper-2.101.tar.gz | tar xvf - cd Data-Dumper-2.101 perl Makefile.PL make test make install gzip -cd DBI-1.13.tar.gz | tar xf - cd DBI-1.13 perl Makefile.PL make make test make install gzip -cd Data-ShowTable-3.3.tar.gz | tar xf - cd Data-ShowTable-3.3 perl Makefile.PL make make install # Don't try make test, the test suite is broken

INSTALLATION:

1. Unpack the archive

sh Data-ShowTable-3.1.shar

or: gnutar xvfz Data-ShowTable-3.1.tar.gz

2. Generate the ``Makefile'':

perl Makefile.PL

Be sure that you are using perl 5.002 or later.

3. Make the install files:

make

4. Test the new files:

make test

5. Install the modules and ``showtable'' program into the configured Perl library and binary directories.

make install cd .. gzip -cd Msql-Mysql-modules-1.2217.tar.gz | tar xf - cd Msql-Mysql-modules-1.2217 perl Makefile.PL make make test make install

During ``perl Makefile.PL'' you will be prompted some questions. In particular you have to choose the installed drivers (MySQL, mSQL2 and/or mSQL1). The MySQL driver will be called DBD::mysql, a single mSQL driver will be called DBD::mSQL. If you want to support both mSQL1 and mSQL2, they former will be DBD::mSQL1. (This information is taken directly from the README and INSTALLATION files of the various packages, as well the MySQL manual. )

[ TOC ]

Brett Winn <brett@panomnia.com> [ TOC ]

[ TOC ]