stargeek
PHP news website logo.
home    PHP scripts    articles    seo tools    links    search    contact    shop    realtors


Fun with Perl, DBI and mysql I just spent a nice a ...







Fun with Perl, DBI and mysql I just
spent a nice a ...

Fun with Perl, DBI and mysql I just
spent a nice a ...
03/13/2003 10:22 AM


Fun with Perl, DBI and mysql
I just spent a nice afternoon reinstalling perl (who knew that the multithreaded version of 5.8 didn't work with DBI? Ok, a lot of people but not me), installing DBI and the MySQL DBD driver. "Great", think I, "now I'm ready to go." I grab "Programming the Perl DBI" and dive in... to a bone-dry pool. No connection to my database, no idea why.

Turns out that the connection for mysql is subtly different than that for msql (I don't know why I thought they might be similar; a whimsical moment of hopefulness I suppose). In "PtPDBI" they describe the msql connect as:

dbi:mSQL:hostname:database:port
but for mysql it must be:
dbi:mysql:host=hostname:db=database:port
Took me almost an hour of googling to hunt that little tidbit down, buried deep in someone else's question on some mailing list somewhere. So as a public service I now archive it here for you. Discuss




This is a GrokNews Entry: (what is grok?)





Similar Items

Fun with Perl, DBI and mysql I just spent a nice a ...

Grok Headline matches for Fun with Perl, DBI and mysql I just spent a nice a ...

Perl Developer! - Market Leader! -
Perl,MySQL,Apache


Perl Developer! - Market Leader! -
Perl,MySQL,Apache
02/01/2005 09:51 PM
Alan Morris Recruitment - United Kingdom, London (2005-02-01)

MySQL and Perl for the Web


MySQL and Perl for the Web 04/26/2004 03:49 PM

PERL/MYSQL/C programmer


PERL/MYSQL/C programmer 03/22/2005 04:32 PM
VIVA USA INC - United States, IL, Chicago (2005-03-19)

Perl/MySQL/XML Web developer


Perl/MySQL/XML Web developer 06/28/2004 01:03 PM
Axis Sistemas - Venezuela, Carabobo, Valencia (2004-06-28)

Perl/MySQL Web Developer


Perl/MySQL Web Developer 12/02/2003 01:58 AM
Express Logistics Systems Corp. - United States, CA, Fremont (2003-11-26)

Perl, MySQL Developer


Perl, MySQL Developer 01/26/2004 01:53 PM
LogicNow LTD - United Kingdom, ESSEX (2004-01-26)

Perl/mySQL Web Developers


Perl/mySQL Web Developers 02/12/2004 03:19 PM
Agorist.net - Cyprus, Limassol (2004-02-12)

Perl/mySQL Application Programmer


Perl/mySQL Application Programmer 09/15/2004 11:53 AM
Softwyre - United States, AR, Little Rock (2004-09-15)

PERL ,MySQL, Linux Developer


PERL ,MySQL, Linux Developer 02/10/2004 02:50 AM
HRsmart - United States, TX, Dallas (2004-02-02)

MySQL/Perl Senior Consultant


MySQL/Perl Senior Consultant 01/06/2005 08:10 PM
MySQL - United States, California, Cupertino (2005-01-06)

MySQL Database Engineer - Perl & C++


MySQL Database Engineer - Perl & C++ 03/13/2003 10:21 AM
There, Inc. - United States, California, Menlo Park (2003-03-06)

PHP/Perl/MySQL Programmer for Small ISP


PHP/Perl/MySQL Programmer for Small ISP 11/10/2003 11:32 PM
Peak Internet Solutions - United States, CO, Woodland Park (2003-11-08)

Perl/MySQL programmer for Y! Finance


Perl/MySQL programmer for Y! Finance 12/29/2004 10:19 PM
Yahoo - United States, CA, Sunnyvale (2004-12-29)

Perl/mySQL Membership Management
Software


Perl/mySQL Membership Management
Software
08/13/2004 12:01 AM
OpenCrypt.com - United Kingdom, Suffolk (2004-08-12)

PERL / MySQL programmer for Application
Development


PERL / MySQL programmer for Application
Development
12/19/2004 03:13 PM
Creed Solutions Inc - Canada, ON, Toronto (2004-12-17)

Perl/MySQL programmer for job match site


Perl/MySQL programmer for job match site 08/13/2004 09:42 PM
Table 20 - United States, California, Los Angeles (2004-08-13)

Perl / MySQL programmer for ad serving
company


Perl / MySQL programmer for ad serving
company
05/03/2004 04:37 PM
Right Media - United States, New York, New York (2004-05-03)

Senior Perl & MySQL Web Hosting
Developer


Senior Perl & MySQL Web Hosting
Developer
01/16/2004 11:33 AM
Pro-Quest Resourcing Ltd - United Kingdom, Yorkshire, Sheffield / Leeds Border (2004-01-14)

perl / mysql programmer for web software
development


perl / mysql programmer for web software
development
02/12/2004 06:23 PM
River Styx Internet - Canada, BC, Vancouver (2004-02-12)

Perl developer with MySql for a finance
company


Perl developer with MySql for a finance
company
09/22/2004 02:46 PM
C&D Elite Ltd - United Kingdom, East Sussex, Hastings, East Sussex (2004-09-22)

Junior Perl, Apache, MySQL developer


Junior Perl, Apache, MySQL developer 05/13/2004 05:08 PM
Plus Three - United States, D.C., Washington (2004-05-13)

Perl/MySQL Database Developer for
Political Org


Perl/MySQL Database Developer for
Political Org
12/17/2003 10:42 AM
- United States, DC, Washington (2003-12-17)

Mod Perl / Apache / mySQL / pgSQL
programer


Mod Perl / Apache / mySQL / pgSQL
programer
12/28/2004 04:50 PM
YourSolutions.net, LLC - United States, Ut, Moab (2004-12-28)

Perl, mod_perl, and MySQL - Lifetime
Opportunity!


Perl, mod_perl, and MySQL - Lifetime
Opportunity!
12/19/2003 02:38 PM
The BettyMills Company - United States, CA, San Mateo (2003-12-19)

Full-time Perl/CGI/MYSQL Web Programmer


Full-time Perl/CGI/MYSQL Web Programmer 01/09/2004 09:55 PM
Rolloutsoftware - United States, California, Santa Monica (2004-01-07)

Senior Perl, Apache, MySQL developer


Senior Perl, Apache, MySQL developer 05/13/2004 05:08 PM
Plus Three - United States, D.C., Washington (2004-05-13)

Web Based Perl/MySQL Application
Programmer


Web Based Perl/MySQL Application
Programmer
01/05/2005 04:23 PM
LogicNow LTD - United Kingdom, Essex, Brentwood (2005-01-05)

Perl/mod_perl/Apache/Mysql Programmer


Perl/mod_perl/Apache/Mysql Programmer 03/14/2005 06:04 PM
Shoplet.com - United States, NY, New York (2005-03-10)

Perl/MySQL/Apache/SOAP Development


Perl/MySQL/Apache/SOAP Development 08/27/2004 02:03 PM
Technology Resource Group - United States, Michigan, Metro Detroit (2004-08-27)

Perl MySQL Web Hosting Developer Leeds


Perl MySQL Web Hosting Developer Leeds 04/28/2004 01:01 PM
Pro-Quest Resourcing Ltd - United Kingdom, West Yorkshire, Leeds (2004-04-28)

Perl/MySQL/Linux/Apache Developer


Perl/MySQL/Linux/Apache Developer 09/09/2004 12:39 PM
AlertSite - United States, Florida, Boca Raton (2004-09-09)

Sr. Perl/MySQL Dev. (w/strong
optimization skills)


Sr. Perl/MySQL Dev. (w/strong
optimization skills)
06/03/2004 07:11 AM
COL Search - United States, CA, Silicon Valley (2004-06-02)

Perl/MySql developers - E-commerce -
Database - Financial


Perl/MySql developers - E-commerce -
Database - Financial
03/06/2004 01:58 AM
Digital Landscape - Canada, ON, Whitby (2004-03-02)

Perl/Apache/MySQL Web Developer for
Publishing Company


Perl/Apache/MySQL Web Developer for
Publishing Company
04/04/2005 06:42 PM
SparkNotes.com - United States, NY, New York (2005-04-04)

Experienced Perl/mySQL/Linux MASON
developer!


Experienced Perl/mySQL/Linux MASON
developer!
05/13/2004 03:15 PM
- United States, NV, Incline Village (2004-05-13)

Sr. Perl/MySQL Developer(w/strong
optimization skills)


Sr. Perl/MySQL Developer(w/strong
optimization skills)
04/21/2004 02:05 AM
COL Search - United States, CA, Silicon Valley (2004-04-20)

MySQL/Perl Senior Consultant in
Scandinavia/Germany


MySQL/Perl Senior Consultant in
Scandinavia/Germany
04/13/2005 05:30 PM
MySQL AB - Sweden, Uppsala (2005-04-13)

Junior Software Engineer -
(Perl/MySQL/Linux)


Junior Software Engineer -
(Perl/MySQL/Linux)
07/30/2004 11:59 AM
TechOnLine, Inc. - United States, MA, Bedford (2004-07-28)

Volunteer Perl/MySQL with a passion for
documentary films


Volunteer Perl/MySQL with a passion for
documentary films
05/28/2004 01:43 AM
e screening room - United States, CA, San Rafael (2004-05-27)
Grok Description matches for Fun with Perl, DBI and mysql I just spent a nice a ...
GrokA matches for Fun with Perl, DBI and mysql I just spent a nice a ...

Fun with Perl, DBI and mysql I just spent a nice a ...

The following phrases have been identified by the grok system as matching this entry:

















Also check out:


Grok

Ipod Porn on the
Rise

Brief Abstract of
Wikipedia's
Mesothelioma Cancer
page

Get first aid
instructions in your
cell phone

IE is crap
JSPWiki gains
podcasting support

If you've managed to
get InnoDB working
with MySQL ...

I released a
packaging of some
DJB tools and some
...

After writing that
last post I got to
thinking: th ...

Speaking of
security, a new
Security Update
appear ...

Kip Knight of Prism
Research has
responded to my c
...

This posting, mostly
about rsync, is
aimed at peop ...

Apple plans to debut
an on-line music
service for ...

Speaking of
Camino...If you are
thinking about gra
...

Because it lacks
automatic update
notification, it ...

I'd like to add some
more information on
the Ximia ...

The Best
Battleground for
Linux?

The Next Big Web
Thing - Really

Unix System Best
Bets

Microsoft's Source
Code Actions Speak
Louder Than Words

The Internet We
Deserve

Microsoft Ships
Enterprise IM Beta

Linux and Java:
Signpost for the
Future

SCO Sues IBM Over
Unix

Microsoft To Debut
Office Beta; Sun
Bows New StarOffice

Has OS Emulation
Come of Age?

The Ultimate Lock-In
Safari Width 1.0
HomeRun 1.2.2
Web Image Maker 1.0
IE Cache Trasher X
1.4

Word Counter 1.0
Happy birthday Rob!
Mac OS X Hints:
Return the short
username in
AppleScript

NetRestore 1.1.1
WebTunes 1.0
Purgatory Design:
Intaglio demo
available

Apple: Java 1.4.1
available

CocoaMySQL 0.4
MacDevCenter:
Announcing the Mac
OS X Innovators
Contest

Mac OS X Hints: A
web search script
for LaunchBar

ScriptBuilders News
Monkeybread Software
updates their
REALbasic Plugin
Collection

Back up user prefs
2.3.7

Apple Bites Into
Music Downloads?

AppleScript: Speak
the sender of a mail
item in Mail

Mike and Daniel's
Adventures in C#

Vulnerability in man
< 1.5l

SOHO Routefinder 550
VPN, DoS and Buffer
Overflow

GLSA: ethereal
(200303-10)

Re: Corsaire
Security Advisory -
Clearswift
MAILsweeper MIME
attachme nt evasion
issue

802.11b DoS exploit
[Opera 7/6] Long
Filename Buffer
Overflow
Vulnerability in
Download

Re: .MHT Buffer
Overflow in Internet
Explorer

Re: [Summary of
Responses] Bound by
Tradition: A
sampling of the
security posture of
the Internet's DNS
servers

pgp4pine stack
overflow
vulnerability

what is grok?