Re: MySQL
On Wed, Dec 08, 2004 at 11:55:57PM -0800, Mark Wheeler wrote: Hi, Well, I'm about to take the plunge and begin to learn MySQL. I have Apache and Perl all running great (stock installs), but I'm not sure how to get started with installing MySQL. I guess what I'm asking is, can some one share some good links/pointers on installing MySQL. As well, links on USING MySQL with Perl. I'm not planning on doing any huge things with multiple databases, just some basic info to be stored and then searched through when needed. I could do what I need in a flat file DB, but want to learn how to use MySQL. Any pointers anyone could give would be greatly appreciated. well, for using Perl there's dbi.perl.org which explains how Perl talks to databases; the book mentioned on their home page (Programming the Perl DBI) is also quite good if you want to learn more. To talk to MySQL you need to know about the driver DBD::mysql: http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm I find the documentation on mysql.com a good source on the installation and configuration of MySQL and I liked the book by Michael Kofler - though I read the originial (German) version of the book and don't know how good the translation is. Regards chris
Re: MySQL
On Dec 9, 2004, at 2:55 AM, Mark Wheeler wrote: I guess what I'm asking is, can some one share some good links/pointers on installing MySQL. Link: http://dev.mysql.com/downloads/mysql/4.1.html Pointer: Download the installer. Run it. As well, links on USING MySQL with Perl. Check the archives - installing DBD::mysql is the hard part. sherm-- Cocoa programming in Perl: http://camelbones.sourceforge.net Hire me! My resume: http://www.dot-app.org
Re: MySQL
On Thu, Dec 09, 2004 at 09:35:34AM +0100, Christian Schneider wrote: On Wed, Dec 08, 2004 at 11:55:57PM -0800, Mark Wheeler wrote: Hi, Well, I'm about to take the plunge and begin to learn MySQL. I have Apache and Perl all running great (stock installs), but I'm not sure how to get started with installing MySQL. I guess what I'm asking is, can some one share some good links/pointers on installing MySQL. As well, links on USING MySQL with Perl. I'm not planning on doing any huge things with multiple databases, just some basic info to be stored and then searched through when needed. In addition to the Perl details below, you can install MySQL (or PostgreSQL (resisting starting religous war) ) with DarwinPorts or fink. http://darwinports.opendarwin.org/ http://fink.sourceforge.net/ hth Michael I could do what I need in a flat file DB, but want to learn how to use MySQL. Any pointers anyone could give would be greatly appreciated. well, for using Perl there's dbi.perl.org which explains how Perl talks to databases; the book mentioned on their home page (Programming the Perl DBI) is also quite good if you want to learn more. To talk to MySQL you need to know about the driver DBD::mysql: http://search.cpan.org/~rudy/DBD-mysql-2.9004/lib/DBD/mysql.pm I find the documentation on mysql.com a good source on the installation and configuration of MySQL and I liked the book by Michael Kofler - though I read the originial (German) version of the book and don't know how good the translation is. Regards chris -- Dr Michael A. Maibaum internet: [EMAIL PROTECTED] http://mike.maibaum.org/ voice: [m] 07813 713 952 [w] (020) 7679 3890
Re: MySQL
Paul DuBois's books on MySQL have been pretty good for me. I got a lot out of the one called, I think, Perl and MySQL for the Web. It's been over a year, but the MySQL lists seemed to be a lot of help: http://marc.theaimsgroup.com/?l=mysqlr=1w=2 (These days I seem to be messing around with PostGreSQL and xindice, mostly.)
Re: MySQL
On Thu, 9 Dec 2004 22:10:04 +0900, Joel Rees [EMAIL PROTECTED] wrote: Paul DuBois's books on MySQL have been pretty good for me. I got a lot out of the one called, I think, Perl and MySQL for the Web. It's been over a year, but the MySQL lists seemed to be a lot of help: http://marc.theaimsgroup.com/?l=mysqlr=1w=2 (These days I seem to be messing around with PostGreSQL and xindice, mostly.) The way I learned, and the reference I still use is Anthony Butcher's _Teach Yourself MySQL in 21 Days_ from SMS, which has a fairly decent chapter on DBD::mysql as well as being for my money the best general intro to MySQL. The _Perl Cookbook_ also has a quick and dirty intro to DBI and DBD::MySQL, and if you're going to be regularly using perl to solve database problems, _Programming the Perl DBI_ is indispensible. HTH, --jay savage
Re: MySQL
Sherm Pendley wrote: On Dec 9, 2004, at 2:55 AM, Mark Wheeler wrote: I guess what I'm asking is, can some one share some good links/pointers on installing MySQL. As well, links on USING MySQL with Perl. Check the archives - installing DBD::mysql is the hard part. Indeed! I think I've finally memorized it, thanks to this list. ;) Pete
Re: MySQL
Hi all, Thanks so much for your input. I think my plan of attack, for now is as follows. 1. First, I'll check the archives on installing DBD::mysql. Then I'll actually install MySQL using Sherm's link. One question regarding that. Which would be the best to install? There are three versions - Standard, Max, and Debug. I'm presuming Standard or Max. 2. After that is installed, I'm leaning (without having looked at the archives, yet) toward using fink to install DBD::mysql. I installed Image/PerlMagick with fink and that went fine, so I thought I'd try it again with DBD::mysql. However, on CPAN there are two different versions. DBD::mysql and Bundle::DBD::mysql. The bundle looks tempting, but is all that is installed necessary? Does the above sound, well, sound? Thanks, Mark
Re: MySQL
On Thu, Dec 09, 2004 at 10:10:04PM +0900, Joel Rees wrote: Paul DuBois's books on MySQL have been pretty good for me. I got a lot out of the one called, I think, Perl and MySQL for the Web. I would also recommend his MySQL Cookbook from ORA. Very helpful. dha -- David H. Adler - [EMAIL PROTECTED] - http://www.panix.com/~dha/ Hulk smash! Hulk kill! Hulk do ironing! - subbes
