Command Line Perl and mySQL database interface under XP

[andycruce]

I have installed active state perl 5.6 and have been using it with Perl Builder 2 to develop web applications. I am now moving the next state of my development where I will be relpacing a flat file data base with a realtional data base, mySQL.

I have successfully installed mySQL on my windows system and now need to figure out how to get the DBI interface for perl and the DBD for mySQL. I went to cpan and when I clicked to get the DBI all I got was a documentation listing, no opportunity to download the DBI itself.

Also I am not sure where to find the DBD for mySQL or how to install it.

Finally, some of the installation instructions imply that you use perl from a command line to do some of the installation. I haven't done this before since all the work I have done is in PerlBuilder 2 (IDE for Perl).

I tried to run c:\Perl\bin\perl5.6.1.exe from the run command and it brings up a command window that says it is running perl5.6.1. It lets me type stuff in but nothing ever happens. How to I run perl from a commad line under windows xp.

It seems that this should be pretty easy but I must be missing something obvious.

Thanks for any help

Andy Cruce

 

[avili]

hello to you.

you can download the dbi from

http://search.cpan.org/author/JWIED/DBD-mysql-2.1020/

this is the most recent version.

you have there all the installation information.

 

[CoronaB]

run the ppm3 batch file, which is in the perl/bin dir, at the ppm> prompt type "search *". it will look around for a while before returning a huge list of packages that you can download. then type "install" followed by either the package's number or the name of the package you want ot install, in this case "DBI". also, my i reccomend that you get the DBI:mySQL module as well.