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


Thanks 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]

Reply via email to