comment on

Yes true it's bioinformatics, but I don't need any modules, I have my data in the text file...
I wanted to start using Mysql with Perl but I can't seem to be able to install the Mysql module. I tried CPAN but the command:

 perl -MCPAN -e 'install Mysql'
[download]

returns:

cpan[9]> install Mysql
Running install for module 'Mysql'
Running make for C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz
Checksum for /home/leo/.cpan/sources/authors/id/C/CA/CAPTTOFU/DBD-mysq
+l-3.0008.tar.gz ok
DBD-mysql-3.0008/
DBD-mysql-3.0008/ChangeLog
DBD-mysql-3.0008/constants.h
DBD-mysql-3.0008/dbdimp.c
DBD-mysql-3.0008/dbdimp.h
DBD-mysql-3.0008/eg/
DBD-mysql-3.0008/eg/prepare_memory_usage.pl
DBD-mysql-3.0008/eg/proc_example1.pl
DBD-mysql-3.0008/eg/proc_example2.pl
DBD-mysql-3.0008/eg/proc_example3.pl
DBD-mysql-3.0008/INSTALL.html
DBD-mysql-3.0008/lib/
DBD-mysql-3.0008/lib/Bundle/
DBD-mysql-3.0008/lib/Bundle/DBD/
DBD-mysql-3.0008/lib/Bundle/DBD/mysql.pm
DBD-mysql-3.0008/lib/DBD/
DBD-mysql-3.0008/lib/DBD/mysql/
DBD-mysql-3.0008/lib/DBD/mysql/GetInfo.pm
DBD-mysql-3.0008/lib/DBD/mysql/INSTALL.pod
DBD-mysql-3.0008/lib/DBD/mysql.pm
DBD-mysql-3.0008/lib/Mysql/
DBD-mysql-3.0008/lib/Mysql/Statement.pm
DBD-mysql-3.0008/lib/Mysql.pm
DBD-mysql-3.0008/Makefile.PL
DBD-mysql-3.0008/Makefile.PL.embedded
DBD-mysql-3.0008/MANIFEST
DBD-mysql-3.0008/MANIFEST.SKIP
DBD-mysql-3.0008/META.yml
DBD-mysql-3.0008/myld
DBD-mysql-3.0008/mysql.xs
DBD-mysql-3.0008/README
DBD-mysql-3.0008/t/
DBD-mysql-3.0008/t/00base.t
DBD-mysql-3.0008/t/10dsnlist.t
DBD-mysql-3.0008/t/20createdrop.t
DBD-mysql-3.0008/t/30insertfetch.t
DBD-mysql-3.0008/t/35limit.t
DBD-mysql-3.0008/t/35prepare.t
DBD-mysql-3.0008/t/40bindparam.t
DBD-mysql-3.0008/t/40bindparam2.t
DBD-mysql-3.0008/t/40blobs.t
DBD-mysql-3.0008/t/40listfields.t
DBD-mysql-3.0008/t/40nulls.t
DBD-mysql-3.0008/t/40numrows.t
DBD-mysql-3.0008/t/41bindparam.t
DBD-mysql-3.0008/t/41blobs_prepare.t
DBD-mysql-3.0008/t/42bindparam.t
DBD-mysql-3.0008/t/50chopblanks.t
DBD-mysql-3.0008/t/50commit.t
DBD-mysql-3.0008/t/60leaks.t
DBD-mysql-3.0008/t/dbdadmin.t
DBD-mysql-3.0008/t/insertid.t
DBD-mysql-3.0008/t/lib.pl
DBD-mysql-3.0008/t/mysql.dbtest
DBD-mysql-3.0008/t/param_values.t
DBD-mysql-3.0008/t/._prepare_noerror.t
DBD-mysql-3.0008/t/prepare_noerror.t
DBD-mysql-3.0008/t/texecute.t
DBD-mysql-3.0008/TODO

  CPAN.pm: Going to build C/CA/CAPTTOFU/DBD-mysql-3.0008.tar.gz

Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 76.

Cannot find the file 'mysql_config'! Your execution PATH doesn't seem 
to contain the path to mysql_config. Resorting to guessed values!
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Can't exec "mysql_config": No such file or directory at Makefile.PL li
+ne 454.
Failed to determine directory of mysql.h. Use

  perl Makefile.PL --cflags=-I<dir>

to set this directory. For details see the INSTALL.html file,
section "C Compiler flags" or type

  perl Makefile.PL --help
Warning: No success on command[/usr/bin/perl Makefile.PL INSTALLDIRS=s
+ite]
  CAPTTOFU/DBD-mysql-3.0008.tar.gz
  /usr/bin/perl Makefile.PL INSTALLDIRS=site -- NOT OK
Running make test
  Make had some problems, won't test
Running make install
  Make had some problems, won't install
Failed during this command:
 CAPTTOFU/DBD-mysql-3.0008.tar.gz             : writemakefile NO '/usr
+/bin/perl Makefile.PL INSTALLDIRS=site' returned status 512
[download]

In reply to Re^2: Efficient way to handle huge number of records? by Anonymous Monk
in thread Efficient way to handle huge number of records? by Anonymous Monk

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:
	&		`&`
	<		`<`
	>		`>`
	[		`[`
	]		`]`

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.