SpirirHost Support Centre: MySQL Reference Manual p.141

<< previous page -- table of contents -- next page >>

Chapter_1

Chapter_2

Chapter_3

Chapter_4

Chapter_5

Return to Table of Contents

Table of Contents
1. General Information
2. MySQL Installation
3. Tutorial Introduction
4. Database Administration
5. MySQL Optimisation
6. MySQL Language Reference
7. MySQL Table Types
8. MySQL APIs
9. Extending MySQL

Chapter 2: MySQL Installation 141 ppm> install DBI If this succeeds, run the following command: install \ ftp://ftp.de.uu.net/pub/CPAN/authors/id/JWIED/DBD-mysql-1.2212.x86. The above should work at least with ActiveState Perl Version 5.6. If you can't get the above to work, you should instead install the MyODBC driver and connect to MySQL server through ODBC: use DBI; $dbh= DBI->connect("DBI:ODBC:$dsn","$user","$password") || die "Got error $DBI::errstr when connecting to $dsn\n"; 2.7.3 Installing the MySQL Perl Distribution on Windows The MySQL Perl distribution contains DBI, DBD:MySQL and DBD:ODBC. Get the Perl distribution for Windows from http://www.mysql.com/download.html. Unzip the distribution in C: so that you get a `C:\PERL' directory. Add the directory `C:\PERL\BIN' to your path. Add the directory `C:\PERL\BIN\MSWIN32-x86-thread' or `C:\PERL\BIN\MSWIN32-x86' to your path. Test that perl works by executing perl -v in a DOS shell. 2.7.4 Problems Using the Perl DBI/DBD Interface If Perl reports that it can't nd the `../mysql/mysql.so' module, then the problem is probably that Perl can't locate the shared library `libmysqlclient.so'. You can x this by any of the following methods: Compile the Msql-Mysql-modules distribution with perl Makefile.PL -static - config rather than perl Makefile.PL. Copy libmysqlclient.so to the directory where your other shared libraries are located (probably `/usr/lib' or `/lib'). On Linux you can add the pathname of the directory where `libmysqlclient.so' is located to the `/etc/ld.so.conf' le. Add the pathname of the directory where `libmysqlclient.so' is located to the LD_ RUN_PATH environment variable. If you get the following errors from DBD-mysql, you are probably using gcc (or using an old binary compiled with gcc): /usr/bin/perl: can't resolve symbol '__moddi3' /usr/bin/perl: can't resolve symbol '__divdi3' Add -L/usr/lib/gcc-lib/... -lgcc to the link command when the `mysql.so' library gets built (check the output from make for `mysql.so' when you compile the Perl client).

MySQL Reference Manual

Home
Hosting Plans \| Domain Registration \| About Us \| Contact Us \| Site Map Terms of Use \| Privacy Policy \| Guarantees Merchant Accounts

SpiritHost - web hosting for spiritual and education sites SpiritHit.com - Religious and Spiritual Portal Copyright © 2002 Dyntex Group, Inc. All Rights Reserved

Return to Table of Contents	Back to top

Web Hosting: Manuals & FAQ's

1. Unix-Based Web Hosting
2. Unix Dedicated Servers
3. Windows Dedicated Servers
4. CuteFTP User’s Guide
5. CuteHTML User’s Guide
6. WS_FTP Pro User's Guide
7. Miva Order User's Guide
8. Miva Merchant User's Guide