On Fri, 27 Sep 2002 10:15:19 +0800
"Robert de los Santos" <[EMAIL PROTECTED]> wrote:
> From: "CYWare" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Subject: Re: [plug] Database Management Software
> Date: Thu, 26 Sep 2002 16:34:46 +0800
> Reply-To: [EMAIL PROTECTED]
>
> > and i was to able to backup some data here... but when i compare it from
> the
> > backup before I restore, there is a significant
> > discrepancy on the file size.
> >
> firebird is able to do garbage collection during backup which basically
> marks space used by old versions of data records as free for reuse.
> Generally, you want firebird to perform garbage collection during backup,
> since the resulting database file may be smaller. Or, you could also
> perform a database sweep prior to the backup.
>
> hope this helps...
>
>
>
> Hi there! thanks for the info about garbage collection,
> Here is a another question,How would I Secure Logs while doing the Restore
> and backup
>
> im doing this command for Data Restoration : /opt/interbase/bin/gbak -c -p
> file.gbak file.gdb
>
> and this for Data backup : /opt/interbase/bin/gbak -t -b file.gdb file.gbak
>
>
> Regards,
> Robert-
Hi Robert,
try to read the help of gbak command
if you want to dump the backup buffer of your database try this command
:to backup:
$gbak -b -t -g -v -y backup.tmp my.gdb my.gbk
:to restore:
$gbak -c -r -p 4096 -v -y restore.tmp my.gbk my.gdb
HTH
--jimmy
_
Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph
To leave: send "unsubscribe" in the body to [EMAIL PROTECTED]
Fully Searchable Archives With Friendly Web Interface at http://marc.free.net.ph
To subscribe to the Linux Newbies' List: send "subscribe" in the body to
[EMAIL PROTECTED]
