2006/2/18, Mike Blezien <[EMAIL PROTECTED]>:
> Hello,
>
> MySQL version: 4.1.10a
>
> we are getting this error when attempting to connect to our MySQL database:
>
> install_driver(mysql) failed: Can't load
> '/usr/lib/perl5/vendor_perl/5.8.3/i386-linux-thread-multi/auto/DBD/mysql/mysql.so'
> for mo
Kristen G. Thorson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 04, 2005 8:21 AM
To: [EMAIL PROTECTED]
Subject: Re: perl/mysql issue...
Bruce,
You can't issue SHOW SLAVE STATUS because you only have permissions on
the livejournal database. Try this: as root or someone with sufficient
p
ummm
i made a mistake in what i posted... a typing error... it should have been
i did the following to configure the mysql database/table
--
$ mysql -uroot -p
mysql> CREATE DATABASE livejournal;
mysql> GRANT ALL PRIVILEGES ON livejournal.* TO
> lj@
bruce wrote:
The problem is in your code, not your db.
hi...
i have the following issue.. i've researched it from google.. but i still
can't quite figure it out...
i'm using a test app with DBI->connect() and i'm getting the following
response... (print/debug statements...)
At 10:52 AM 5/3/05 -0700, [EMAIL PROTECTED] wrote:
>'DBD::mysql::db selectrow_hashref failed: Access denied for user:
>'[EMAIL PROTECTED]' (Using password: NO) at /var/www/html/cgi-bin/DBI/Role.pm
>$ mysql -uroot -p
>mysql> CREATE DATABASE livejournal;
>mysql> GRANT ALL PRIVILEGES ON livejournal.*
Hi all,
I am using DBI and DBD::mysql to connect to a MySQL database from perl and I
would like to get the execution time period after a query, like MySQL
standard client shows.
Sometimes when I work in the standard console client it tells me that there
are x wornings.
How can I see which are tho
Howell, Scott wrote:
Has anyone written a perl script to get records from another database and
write it to a file on mysql's LOAD DATA INFILE format? I just need some
pointers in perl so a LOAD DATA INFILE will be read correctly.
For example, a perl script:
Select * from emp from a Progress databa
> Has anyone written a perl script to get records from another
> database and write it to a file on mysql's LOAD DATA INFILE
> format? I just need some pointers in perl so a LOAD DATA
> INFILE will be read correctly.
You might want to check out Perl's DBI module at search.cpan.org
I use that a
At 17:38 -0700 5/10/02, Jeremy Zawodny wrote:
>On Fri, May 10, 2002 at 08:32:17PM -0400, Amer Neely wrote:
>> > I use Perl, Php, mysql for my applications. I have a great manual for php
>> > for mysql processes. But i do not know any manual for perl yet. Does
>> > anyone know any manual about f
On Fri, May 10, 2002 at 08:32:17PM -0400, Amer Neely wrote:
> > I use Perl, Php, mysql for my applications. I have a great manual for php
> > for mysql processes. But i do not know any manual for perl yet. Does
> > anyone know any manual about for perl-mysql? Better if would be .chm
> > version. T
> I use Perl, Php, mysql for my applications. I have a great manual for php
> for mysql processes. But i do not know any manual for perl yet. Does
> anyone know any manual about for perl-mysql? Better if would be .chm
> version. Thanks.
>
> -Onder
Not online, but the book "MySQL and Perl for the
Hi see perldoc DBI and perldoc DBD::mysql
(search.cpan.org)
Onder Hazaroglu wrote:
>
> I use Perl, Php, mysql for my applications. I have a great manual for php
> for mysql processes. But i do not know any manual for perl yet. Does
> anyone know any manual about for perl-mysql? Better if would
--- Horváth_Szabolcs <[EMAIL PROTECTED]> wrote:
> Hello everyone!
>
> I would like to use my mysql server via Perl.
> Does anyone send me links or documents about it?
> Thanks
> Szabolcs
I am using DBI module in Perl to connect to mySQL database. More
information can be found at the below lin
Shon wrote
> i am trying to write a program in perl and am getting a mysql error from my
> module. here is the error:
>
> DBI::db=HASH(0x294738)->disconnect invalidates 1 active statement handle
> (either destroy statement handles or call finish on them before
> disconnecting) at ./pop.pl line 12
Message -
From: "Mike(mickalo)Blezien" <[EMAIL PROTECTED]>
To: "Shon Stephens" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, February 27, 2002 11:32 AM
Subject: Re: perl mysql DBI::db question
Try moving your $dbh->disconnect call afte
On Wed, 27 Feb 2002 10:40:21 -0600, "nickg" <[EMAIL PROTECTED]> wrote:
>>
>>You need to tell the handler you are finished with your statement, this will
>>free resources, etc..
>>
>>http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish
>>
>>
>>$sql_check->finish;
EXTREMELY out-dated!
MySQL
You need to tell the handler you are finished with your statement, this will
free resources, etc..
http://www.savebaseball.com/mysql/DBD_3.21.X.php3#finish
$sql_check->finish;
my $sql_check = $dbh->prepare("select user,password,prefs from users
where username='$LNAME'");
# I do
Try moving your $dbh->disconnect call after it prints out the fetchrow_array()
my ($t_user,$t_password,$t_prefs) = $sql_check->fetchrow_array();
if($debug_state) {
print "S: $t_user,$t_password,$t_prefs\n";
}
$dbh->disconnect();
If your using an older version of DBI, like 1.13 or
Richard Reina wrote:
> I have a perl->DBI->MySQL database app. that handles everything from my
> order entry to my accounts payable. I am in the process of cleaning up
> a lot of the code I've written to make it easier to maintain. I
> probably use the following DBI staement handle about fifty
let
perl -MCPAN -e shell
be your friend
i /mysql/
will show you all the mysql stuff
or
i /dbi/
even
On Thursday 12 April 2001 01:16, Chris Becker wrote:
> go to perl.com - click CPAN and look for DBI and DBD, and look for docs on
> how to install a perl module. You need to inst
go to perl.com - click CPAN and look for DBI and DBD, and look for docs on
how to install a perl module. You need to install DBI first, then DBD...
hope this helps.
Chris Becker
MCSE MCDBA
===
Idysys
http://www.idysys.com
[EMAIL PROTECTED]
===
-Orig
>Msql-Mysql-modules-1.2215.tar. For the life of me I can't find the
>mysql.h file that it keeps asking for? Any ideas where this is...is it
>a bug with this version.
Type find -name mysql.h
I found mine (MySQL 3.23.36) in /usr/local/mysql/include
Sometimes it helps to use a very basic method
hi.
don't know how much light this will shed on your situation, but mysql.h is
in the include directory under the directory where you installed mysql.
(i.e /opt/mysql/include or /usr/local/mysql/include)
hth. hand.
-ravi
-Original Message-
From: Eric Fegraus [mailto:[EMAIL PROTECTED]]
Eric,
Download the source tarball for mysql from the website and reinstall
using that - the necessary
include files do not come with the redhat rpm.
regads,
P
On Wed, 4 Apr 2001, Eric Fegraus wrote:
>
> Hello,
>
> I have redhat 7.0 with Mysql Ver 8.8 Distrib 3.23.22-beta. This was the
> M
N Sikkandar Dulkarnai wrote:
>
> Hello there,
>
> I just installed "mysql Ver 11.12 Distrib 3.23.33, for sun-solaris2.6 (sparc)". How
>do I insert rows into mysql database.tablevia PERL ?. It would be appreciated if some
>one can send some basic structure of connecting into sql using perl and
25 matches
Mail list logo
