Subject Re: [ib-support] Firebird for Linux
Author Dalton Calford
Hi Helen,

I have never used IB_SQL's (IBO_WISQL .....etc) script utility before
connecting to a database, and I have only used the create database button to
create a database.
I am trying to get a couple of users here at Distributel to start using
Firebird and they have a Access background, so scripting a database is a new
concept to them. I was hoping to plop down a nice utiltiy program in front
of them without alot of training and hand holding.

The command line gbak does not work for us, and it appears to be some sort of
limit on the length of the command line. We commonly use up to 40 or 50 2GB
files to back up one of our history databases, and the command line gbak,
using the service gaff's with 'file not found' errors with a truncated file
name, and if we shorten the path/name combination, it gets farther, but it
does not get all of it.

I was upset that you can not backup/restore from a pipe anymore, as that was
one of the best features of gbak. I was wondering, since gbak can't stream
to a device anymore, how do people backup to streaming tape?

I have found that the latest IBConsole can take as many files as we give it,
so the problem must be in the command line buffer that gbak uses and not a
problem with the backup service.

I will look at IBOConsole and see if it is what we need.

best regards


On Wednesday 19 June 2002 10:49 pm, Helen Borrie wrote:
> At 12:12 PM 19-06-02 +0000, Dalton Calford wrote:
> >I tried to use IB_SQL from Jason Whartons site, and it only creates
> > databases of 1K and dialect 1.
> I just created this database using the IB_SQL script utility:
> set sqldialect 3;
> create database 'y:\gdb_6\test\test_dalton.gdb' page_size 8192 user
> 'sysdba' password 'masterkey';
> What are you doing to create a database with IB_SQL?
> >I tried the latest IBConsole and it only produces 8K pages.
> >What I would like to do is have a tool that will produce Dialect 3
> > databases with 16K page size and that also allows me to perform backups
> > and restores with the larger page size. (Hopefully a linux program, but I
> > will run windows if that is all I have available)
> IMO, you can't beat command-line gbak ;-) straight from a shell or shell
> script. But Martin Schmid's IBBackup (FBBackup) is a very neat Windows
> backup client and works well remotely.
> heLen
> All for Open and Open for All
> Firebird Open SQL Database · ·
> _______________________________________________________
> To unsubscribe from this group, send an email to:
> Your use of Yahoo! Groups is subject to