On Fri, 27 Sep 2002 12:45:31 +0800
"Robert de los Santos" <[EMAIL PROTECTED]> wrote:
> From: Jimmy <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Subject: Re: [plug] FIREBIRD: Database Management software
> Organization: Tricom
> Reply-To: [EMAIL PROTECTED]
>
> On Fri, 27 Sep 2002 10:15:19 +0800
> "Robert de los Santos" <[EMAIL PROTECTED]> wrote:
>
> > 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
>
>
>
> Thanks Jimmy, with such information. Got some question again here ,
> how do i run ISQL and QLI under Linux?
> And what are the Command Options that I can use to Access The
> Database.
>
> What is the Safest way to commit & backup the database?
> Can i backup the database when it is in used? ... or should i let the
> users to logout before doing the backup.
>
>
In the snapshot package of firebird, there's a command (e.g.
/opt/firebird/bin/isql) you can do an sql script to be run by isql
command or you can directly use the isql command.
:to use the isql as an interactive isql cl:
$/opt/firebird/bin/isql yourserver://somelocation/ofyourdb/yourdb.gdb \
-username <user> -password <secret>
:to execute sql script:
$/opt/firebird/bin/isql -i yourscript.sql \
yourserver://somelocation/ofyourdb/yourdb.gdb -username <user> -password
<secret>
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]
