Blog

You will also see in this tutorial the basics of using DBI to perform queries, and display the results. If you were installing support for another database like Oracle, Informix, etc, you would also have to download their DBD modules. An interactive session starts requires you to be connected to the Internet to search the modules repository and you can search for the module you want to install, and later install it. Install the main DBI module as shown here.

The following script let you test if your installation is working fine:! Again, at the ppm prompt type search Data-Table and when found type install Data-Table, as shown here. Richard Richard 1, 2 2 gold badges 23 23 silver badges 51 51 bronze badges. Strawberry or ActiveState Perl? Add a comment.

Sorted by: Reset to default. Highest score default Trending recent votes count more Date modified newest first Date created oldest first. Improve this answer. Raoul Raoul 3, 3 3 gold badges 23 23 silver badges 30 30 bronze badges. Thanks, I’m struggling to find a compiled version to be honest. I have the source code though, guess it’s a case of trying to compile it manually, resolving dependencies etc. Is this right?

Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name.

Email Required, but never shown. As in the case of the header files, the client library is typically not installed by default. The linker needs to know the location and name of the mysqlclient library. This can be done by adding the flags. If you would like to use the static libraries and there are excellent reasons to do so , you need to create a separate directory, copy the static libraries to that place and use the -L switch above to point to your new directory.

For example:. Once you know the name libz. If this seems to be causing problem you may also try to link without gzip libraries. If you are a user of Cygwin the Redhat distribution you already know, it contains a nicely running perl 5. But to install DBD::mysql you have to take a little special action. You’ll only need that library and the header files, you don’t need any other client parts. Continue to use the Windows binaries.

And don’t attempt currently to build the MySQL Server part, it is unneccessary, as MySQL AB does an excellent job to deliver optimized binaries for the mainstream operating systems, and it is told, that the server compiled under Cygwin is unstable.

This prepares the Makefile with the installed Cygwin features. It takes some time, but should finish without error. The –without-server parameter tells configure to only build the clients. Essentially you are now done with this part.

If you want, you may try your compiled binaries shortly; for that, do:. The host -h parameter If you have your MySQL server running on some other box, then please substitute ‘ I’m hunting for a solution to that problem, but have none yet. This was tested with MySQL version 3. I patched the above mentioned test scripts and sent the patches to the author of DBD::mysql Jochen Wiedman. If this is the case for you, install an RPM archive like libz-devel, libgz-devel, zlib-devel or gzlib-devel or something similar.

The usual problem is that this file is located in a directory like. The use of a statically linked library is described in the previous section on linker flags. Finally, if everything else fails, you are not alone. First of all, for an immediate answer, you should look into the archives of the mailing list perl lists.

If you don’t find an appropriate posting and reply in the mailing list, please post a question.

Perl DBI – replace.me

ActivePerl Enterprise Edition guarantees priority access to technical support, indemnification, expert consulting and quality-assured language builds. Privacy Policy Contact Us Support. All rights reserved. All other marks are property of their respective owners.

Recent Packages Popular Packages Authors. Download ActivePerl. DBD-mysql 4. Perl 5. Links CPAN. Author Daniel van Eeden. Lastest release version 4. You also normally cannot install development milestone releases DMRs , as these are not usually made available in the native repositories. Before proceeding, we recommend that you check out the other installation options described in Section 2. See Section 2. For Red Hat and similar distributions, the MySQL distribution is divided into a number of separate packages, mysql for the client tools, mysql-server for the server and associated tools, and mysql-libs for the libraries.

The libraries are required if you want to provide connectivity from different languages and environments such as Perl, Python and others. To install, use the yum command to specify the packages that you want to install. For example:. To start the MySQL server use service :. To enable the server to be started and stopped automatically during boot, use chkconfig :. Which enables the MySQL server to be started and stopped automatically at the specified the run levels.

The database tables are automatically created for you, if they do not already exist. On Debian and related distributions, there are two packages for MySQL in their software repositories, mysql-client and mysql-server , for the client and server components respectively. You should specify an explicit version, for example mysql-client