eXtropia: the open web technology company
Technology | Support | Tutorials | Development | About Us | Users | Contact Us
Free support
 ::   Support forums
 ::   Frequently asked questions
 ::   Functional Specifications
 ::   eXtropia Tutorials
 ::   Books by eXtropia
 ::   Other books
 ::   Offsite resources
eXtropia ADT Documentation

Installing MySQL and related Perl modules locally.


[ TOC ]
[ TOC ]

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 ]


AUTHOR

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


[ TOC ]


[ TOC ]
Master Copy URL: http://www.extropia.com/support/docs/adt/
Copyright © 2000-2001 Extropia. All rights reserved.
[ TOC ]
Written by eXtropia.
Last Modified at 09/06/2001