Subject | Re: [ib-support] Server-side backups and restores |
---|---|
Author | Anthony Ison |
Post date | 2003-04-29T03:39:11Z |
Thanks for the response. It is exactly what I asked for.
There is a small difference with what I'm trying to do though...
I am trying to use TIBBackupService with Delphi to achieve the same thing as
gbak. While trying to determine what was wrong, I went back to gbak and
found myself unable to do it there either...
I hope this is not off-topic....
Here is the code I code I am using to backup the database:
lIBBackupService := TIBBackupService.Create(nil);
try
with lIBBackupService do
begin
ServerName := 'localhost'; //DatabaseServerName;
Protocol := TCP;
LoginPrompt := False;
Params.Add('user_name=sysdba');
Params.Add('password=masterkey');
Active := True;
try
Verbose := True;
DatabaseName := DatabaseServerName + ':' + DatabaseLocation;
BackupFile.Add(BackupLocation);
ServiceStart;
while not Eof do
begin
lLine := GetNextLine;
When I execute this, I get the following results:
Backing up database...
gbak: readied database superman:c:\databases\test.gdb for backup
gbak: creating file c:\temp\test.gbk
I then get an exception - 'Error writing data to the connection'.
Any ideas?
There is a small difference with what I'm trying to do though...
I am trying to use TIBBackupService with Delphi to achieve the same thing as
gbak. While trying to determine what was wrong, I went back to gbak and
found myself unable to do it there either...
I hope this is not off-topic....
Here is the code I code I am using to backup the database:
lIBBackupService := TIBBackupService.Create(nil);
try
with lIBBackupService do
begin
ServerName := 'localhost'; //DatabaseServerName;
Protocol := TCP;
LoginPrompt := False;
Params.Add('user_name=sysdba');
Params.Add('password=masterkey');
Active := True;
try
Verbose := True;
DatabaseName := DatabaseServerName + ':' + DatabaseLocation;
BackupFile.Add(BackupLocation);
ServiceStart;
while not Eof do
begin
lLine := GetNextLine;
When I execute this, I get the following results:
Backing up database...
gbak: readied database superman:c:\databases\test.gdb for backup
gbak: creating file c:\temp\test.gbk
I then get an exception - 'Error writing data to the connection'.
Any ideas?
----- Original Message -----
From: ""Nigel Weeks"" <nigel@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Tuesday, April 29, 2003 10:23 AM
Subject: RE: [ib-support] Server-side backups and restores
> Backups across the wire from remote machine to local filesystem:
>
> Under Freebsd/Linux...
> gbak -b -t -user sysdba -pass password superman:/databases/test.gdb
> /test/test.gbk
>
> Under Win32, (I assume, from a .bat file):
> gbak -b -t -user sysdba -pass password superman:c:/databases/database.gdb
> c:/test/test.gbk
>
> I've most likely got the slashes wrong. I've never used win32...
>
> Unless I've misunderstood your email. Sorry if I have...
>
> -----Original Message-----
> From: Anthony Ison [mailto:anthony@...]
> Sent: Tuesday, 29 April 2003 11:15
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Server-side backups and restores
>
>
> Hi all,
>
> I have read on the Borland website that server-side backup and restores
are
> a new feature in Interbase V6. I am currently running 6.0.1.6 and using
the
> following command: 'gbak -service superman:service_mgr
c:\databases\test.gdb
> c:\temp\test.gbk' (where superman is the server, c:\databases is the
> location and c:\temp is where I want a local backup made)
>
> This fails with the message 'ERROR: cannot open backup file
> c:\temp\test.gbk'. I believe this is because it is trying to backup to
the
> server machine, which doesn't have that directory.... Am I doing
something
> wrong, or is this functionality broken? I thought I saw a post somewhere
> that suggested it was broken...
>
> I would like to backup a database from a different computer to the local
> machine. Is it possible to do this with the current version of Interbase?
> (or Firebird...)
>
> Thanks in advance.
> Anthony
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>