On Tue, Jul 06, 2004 at 06:11:18PM +0200, Sapet Frederic wrote:
On Tue, 6 Jul 2004 16:07:28 +0100
Tim Bunce [EMAIL PROTECTED] wrote:
I think in some cases it's better to use
$sth = $dbh-column_info(...)
:)
I am using
Oracle 8.1.5
DBI 1.42
DBD::Oracle ?
I tried to use
I want to automate a mysql backup
Can this be done via perl and how?
I quick search on google for automate mysql backup perl dbi
revealed this as one of the 1st 5 links:
http://www.csc.liv.ac.uk/~u2pj/SQL_Perl.htm
Check out RW MySQL Dump - looks to me like it might be just what
you're looking for. Or if you still want to do it yourself, just
reading its
I am using
Oracle 8.1.5
DBI 1.42
and $DBD::Oracle::VERSION = '1.06';
I laucnh the script like this :
DBI_TRACE=2 column_info.pl
my script looks like:
#!/bin/perl -w
use strict;
use diagnostics;
use warnings;
use DBI;
my $dbh = DBI-connect('dbi:Oracle:gpdvt', 'OSNP', 'pwd') or die
Hi list,
I am trying to install DBI-1.43 on Solaris 8, I am getting the following errors when I
run make. Which DBI version works on Solaris 8?, please let me know.
bash-2.03# make
/usr/bin/perl -I/usr/local/lib/perl5/5.6.1/sun4-solaris -I/usr/local/lib/perl5/5.6.1
-MExtUtils::Command -e
On Wed, 2004-07-07 at 16:15, Robert wrote:
Hi list,
I am trying to install DBI-1.43 on Solaris 8, I am getting the
following errors when I run make. Which DBI version works on Solaris
8?, please let me know.
/usr/ccs/bin/as: /var/tmp/cc3Rrlgg.s, line 5255: error: unknown opcode
Tim Bunce wrote:
On Tue, Jun 01, 2004 at 11:35:10AM +0200, Silvio Wanka wrote:
Tim Bunce wrote:
The next release emulates OCILobWriteAppend for Oracle 9.
Why 9 and not 8.1 ?
OCILobWriteAppend is buggy upto and including 8.1.7.
OK, I will wait for it.
BTW. one additional note for HP-UX. The
I just compiled a simple C program which is working fine.
Michael Peppler [EMAIL PROTECTED] wrote:On Wed, 2004-07-07 at 16:15, Robert wrote:
Hi list,
I am trying to install DBI-1.43 on Solaris 8, I am getting the
following errors when I run make. Which DBI version works on Solaris
8?,
On Wed, Jul 07, 2004 at 04:12:08PM +0200, Sapet Frederic wrote:
I am using
Oracle 8.1.5
DBI 1.42
and $DBD::Oracle::VERSION = '1.06';
column_info= (not implemented) ?
I don't understand :0(
Upgrade.
Tim.
I believe mysql also ships with mysqlhotcopy (which I wrote)
you may find it useful.
Tim.
On Wed, Jul 07, 2004 at 10:05:42AM -0400, Hardy Merrill wrote:
I quick search on google for automate mysql backup perl dbi
revealed this as one of the 1st 5 links:
The DBI README says It is best to use a Perl that was built on the
system you are trying to use and it's also important to use the
same compiler that was used to build the Perl you are using.
That's probably relevant here.
Tim.
On Wed, Jul 07, 2004 at 08:07:35AM -0700, Robert wrote:
I just
A bit OT here, but I'm curious - does mysqlhotcopy allow you to do a
backup without shutting down MySQL?
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
I know this is over-simplifying, but couldn't automating MySQL backups
with mysqlhotcopy be as simple as adding a MySQL user with read(?)
Hi,
Can any suggest , some methods for migrating data stored in column of
TEXT type to column of IMAGE type.
Thanks
Jamsheed
[EMAIL PROTECTED] wrote:
Hi,
Can any suggest , some methods for migrating data stored in column of
TEXT type to column of IMAGE type in SYBASE DATABSE.
Thanks
Jamsheed
On Wed, Jul 07, 2004 at 01:41:19PM -0400, Hardy Merrill wrote:
A bit OT here, but I'm curious - does mysqlhotcopy allow you to do a
backup without shutting down MySQL?
Yes, hence hot copy.
http://dev.mysql.com/doc/mysql/en/mysqlhotcopy.html
[Umm, ought to ask them to acknowledge that I wrote
On Wed, 2004-07-07 at 20:03, Jamsheed wrote:
Hi,
Can any suggest , some methods for migrating data stored in column of
TEXT type to column of IMAGE type.
With Sybase?
I'd use bcp, and copy the entire table to a disk file, alter the table
definition, and then load the table back in.
Michael,
I'm assuming that you have the CPAN shell installed ... if not .. do so
perl -MCPAN -e 'install Bundle::CPAN'
Try this from http://search.cpan.org/~timb/DBI/lib/Bundle/DBI.pm
perl -MCPAN -e 'install Bundle::DBI'
I just installed it last week .. just fine :-)
-Original
If I run the test case code enclosed below against an Oracle database
(first arg dbi:Oracle:blah) the memory consumption goes continuously up
from a few MB to eventually more than 100MB.
If I run the same code against a MySQL database (first arg
dbi:mysql:database=blah, using DBD::mysql
In case it helps anyone figuring out what's wrong (Tim?) I created a
trace with level 9 for the loop 1..3.
DBI 1.38-ithread dispatch trace level set to 9
- DBI-connect(dbi:Oracle:blahh, lapp, , HASH(0x1801180))
- DBI-install_driver(Oracle) for darwin perl=5.008001 pid=8122
Alright. So after a lot of trial and error and poking around here is
what I found. I observed the leak as described below on a G5 running
Panther/perl 5.8.1, but not on a G4 laptop running Jaguar/perl 5.6.0,
when I kept DBI and DBD::Oracle versions identical on both boxes.
Since everything is
20 matches
Mail list logo