Using MySQL with Perl

[philsfan17]

I'm having a problem running a perl script that uses mySQL. I have
installed both DBI and DBD-mysql using ppm, but when I run a script
that has use mysql in it, I get this error:

Had to create DBI::_dbistate unexpectedly at C:/Perl/lib/DynaLoader.pm
line 253.

Does anyone have any idea what I'm doing wrong?

Thanks!
-Shane

 

[Jim Keenan]

I'm having a problem running a perl script that uses mySQL. I have
installed both DBI and DBD-mysql using ppm, but when I run a script
that has use mysql in it, I get this error:

Please show us your code. Better still, try to present the smallest
possible amount of code that reproduces the error.

jimk

 

[philsfan17]

This is all I'm doing:

#!/bin/perl -w

use mysql;

 

[ioneabu]

This is all I'm doing:

#!/bin/perl -w

use mysql;

I use DBI all the time, but I do:

use DBI;

I don't know what mysql.pm is. Is it your own module?

wana

 

[A. Sinan Unur]

This is all I'm doing:

#!/bin/perl -w

use mysql;

First, read <URL: http://tinyurl.com/6z7k2> (thanks Paul!). Then, read

perldoc DBI

Sinan

 

[philsfan17]

Ah, actually I was looking at the code on this page:
http://search.cpan.org/dist/DBD-mysql/lib/Mysql.pm#OBSOLETE_SOFTWARE

But as the bookmark on the end tells you - I missed a few lines about
the separate mysql module being obsolute at this point.

So I guess I can use DBI to interact with mysql then.