PEPPLER.ORG
Michael Peppler
Sybase Consulting
Menu
Home
Sybase on Linux
Install Guide for Sybase on Linux
General Sybase Resources
General Perl Resources
Freeware
Sybperl
Sybase::Simple
DBD::Sybase
BCP Tool
Bug Tracker
Mailing List Archive
Downloads Directory
FAQs
Sybase on Linux FAQ
Sybperl FAQ
Personal
Michael Peppler's resume

sybperl-l Archive

Up    Prev    Next    

From: Michael Peppler <mpeppler at MBAY dot NET>
Subject: Re: dump db through perl
Date: Jun 5 1998 9:06PM

s9ulzf writes:
 > Hi Michael,
 > 
 > I did it both ways and compared:
 >  
 > 	1) through perl.
 > 
 > 	2) using the exact command inside isql.

My guess is that you're not letting it finish in sybperl (ie you are
not looping through all the results by doing something like:

$dbh->dbcmd("dump...");
$dbh->dbsqlexec;
while($dbh->dbresults != NO_MORE_RESULTS) {
	;
}

Michael

 > 
 > Thanks,
 > 
 > Lin 
 > 
 > On Fri, 5 Jun 1998, Michael Peppler wrote:
 > 
 > > s9ulzf writes:
 > >  > The problem is that the dump file itself is about 2/3 of the size as it
 > >  > should be.
 > > 
 > > How do you know that it's too small?
 > > 
 > > The dump file will not be as large as the configured space for the DB
 > > if the DB is not full (or nearly so).
 > > 
 > > Michael
 > > -- 
 > > Michael Peppler         -||-  Data Migrations Inc.
 > > mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
 > > Int. Sybase User Group  -||-  http://www.isug.com
 > > 
 > > 
 > 
 > 

-- 
Michael Peppler         -||-  Data Migrations Inc.
mpeppler@datamig.com    -||-  http://www.mbay.net/~mpeppler
Int. Sybase User Group  -||-  http://www.isug.com