1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123
|
DBD::mysql - A Perl5 Database Interface to the MySQL database
=============================================================
The driver installation is described in
INSTALL.html
In short: If you are using
Windows/ActivePerl
1.) If you need to use an HTTP Proxy, set the environment
variable http_proxy, for example like this:
set http_proxy=http://myproxy.com:8080/
2.) The actual installation is as simple as
ppm install DBI
ppm install DBD::mysql
As of this writing, the above procedure won't work with
ActivePerl 5.8.0, because so far a PPM for DBD::mysql is
not available from the ActiveState server. I don't know
why. However, Randy Kobes has kindly donated a PPM package
to his own repository. You can use this as follows:
ppm install http://theoryx5.uwinnipeg.ca/ppms/DBD-mysql.ppd
Windows/CygWin
Unfortunately it seems that the usual MySQL windows binaries
cannot be combined with the CygWin libraries. At least I don't
know how. In other words: You need to compile your own MySQL
client binaries. In what follows I assume that you have
downloaded and extracted the MySQL sources and the DBD::mysq
sources to /usr/local/src. The following steps should do:
cd /usr/local/src/mysql-4.0.9
./configure --without-server --prefix=/usr/local/mysql-4.0.9
make
make install
cd /usr/local/src/DBD-mysql-2.1023
perl Makefile.PL \
--libs="-L/usr/local/mysql-4.0.9/lib/mysql -lmysqlclient -lz" \
--cflags=-I/usr/local/mysql-4.0.9/include/mysql \
--testhost=127.0.0.1
make
make test # Some minor error messages can be ignored here
make install
Windows/CygWin (to build with embedded MySQL too)
First, build MySQL
tar -xzf mysql-5.0.51b.tar.gz
cd mysql-5.0.51b/
./configure --without-server --with-embedded-server
make
make install
Then build DBD::mysqlEmb
cpan
look DBD::mysql
perl Makefile.PL --force-embedded
make
make install
Test with the following snippet
perl -e 'use DBI; $dbh = DBI->connect("DBI:mysqlEmb:database=test;mysql_embedded=1;mysql_embedded_options=--help,--verbose","a","b");'
If your build is OK, this will print the mysql embedded help.
Linux/Red Hat (you may prefer gnorpm to use)
rpm -i mysql mysql-devel mysql-server
rpm -i perl-DBI
rpm -i DBD-MySQL
rpm -i zlib-devel
Linux/SuSEs(you may prefer to use yast)
rpm -i mysql mysql-client mysql-devel mysql-shared
rpm -i perl-DBI
rpm -i perl-Msql-Mysql-modules
Linux/Mandrake (you may prefer to use any Mandrake specific tool?)
rpm -i MySQL MySQL-client MySQL-devel MySQL-shared
rpm -i perl-DBI
rpm -i perl-Mysql
rpm -i zlib-devel
Linux/Debian
Install the packages
mysql-client mysql-server mysql-doc mysql-common
libdbi-perl lidbd-mysql-perl
No idea how one does install these under Debian, but I am
sure you know. :-)
For others, or in case of problems see INSTALL.html.
The drivers documentation can be obtained with
perldoc lib/DBD/mysql.pod
or
pod2html lib/DBD/mysql.pod >mysql.html
The driver is maintained by a mailing list:
perl@lists.mysql.com
You can also get help from the maintainer, Patrick Galbraith patg@patg.net
|