Scenario:


Windows installation Cygwin
My SQL? 5.0 downloaded, configured and installed from the Windows package.

mysql command line utility fails to run 100% under cygwin, but one can live with it. A sudden urge to hack some Perl scripts with My SQL stuff


Solution: 

perl -MCPAN -e'install DBI::DBD' 
perl -MCPAN -e'install DBD::mysql'

[download]

Problems:

DBD::mysql fails to compile claiming it Can't exec "mysql_config": No such file or directory at Makefile.PL

Solution:

Download the My SQL? source code (.tar.gz) from http://dev.mysql.com/downloads/mysql/5.0.html

Unpack it to a temporary location 

./configure --prefix=/usr/local/mysql --without-server

[download]

I get stuck here.... no matter how many times I re-download , re -gunzip , re - tar (untar) ,.... It just DOESNOT ./.configure!!!!!

what should I do??? PLS HELP ME.. like Hollie and Prasad suggested.. I have started to dwonload all the modules that I need.. but now what do I do?? 

make 
make install

[download]
[this is documented in the DBD::Mysql INSTALL file (here), but who RTFM anyway?] 
By this time, you will have a beautiful set of mysql command line util
+ities compiled under Cygwin on /usr/local/mysql

cd .cpan/build/DBD-mysql-3.0002/ 
cp /usr/local/mysql/bin/mysql_config . 
perl Makefile.PL --testhost=127.0.0.1

(this will give you a couple of errors regarding missing header files,
+ mysqld_error.h and possibly others. open the offending file, change 
+the #include <file.h> to #include "file.h". The missing files are sti
+ll on the My SQL? source code location and should be copied here. )

[download]

Thanks...
PS: The above mentioned sequence is taken from another place where someone had the same problem which got solved... but why would it not happen here with me??!!

Sweta.

20060627 Janitored by Corion: Added formatting, code tags, removed excess whitespace, linkified link as per Writeup Formatting Tips

In reply to DBD --- not Installing! by swetashah23

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.