FirebirdSQL/1/4

domdelpas
=== ä½¿ç¨iSQLæ¸¬è©¦--å¨Linuxä¸ç¤ºç¯ ===

== ç¬¬ä¸æ¥ â ååè³æåº« ==
$cd /opt/firebird/bin

$isql -user sysdba -password <password*>

SQL>connect /opt/firebird/examples/employee.gdb;

SQL>select * from sales;

SQL>select rdb$relation_name from rdb$relations;

SQL>help;

SQL>quit;

== ç¬¬äºæ¥ - å»ºç«è³æåº«è·¯å¾åæ¬é ==
:1) åå¦firebirdç®éä¸åå¨,è«ç¨rootèº«åå»ºç«ï¼
::$su - root
::$mkdir -p /var/firebird
::$chown firebird:firebird /var/firebird
:2) å»ºç«firebirdæ¬éè³ææª
::run the following script:
::$cd /opt/firebird/bin
::$./createDBAlias.sh test.fdb /var/firebird/test.fdb

:3) 
::$vi /opt/firebird/aliases.conf and add the line at the end of the file:
::test.fdb /var/firebird/test.fdb
:4) å»ºç«è³æåº«:
::$/opt/firebird/isql -u sysdba -p <password*>
::SQL>create database 'localhost:test.fdb';
::SQL>quit;
:5) å¨è¨å®æª/opt/firebird/firebird.conf æååæ¸DatabaseAccess,å¯ä»¥è®æåè¨å®å¥å.
::$/opt/firebird/isql -u sysdba -p <password*>
::SQL>create database '/var/firebird/test.fdb';
::SQL>quit;

:$/opt/firebird/isql -u sysdba -p <password*>
::SQL>connect '/var/firebird/test.fdb';
::SQL>quit;


æ³¨ï¼å¯ç¢¼åæ¼å¯ç¢¼æªã/opt/firebird/SYSDBA.password