Programming/DB (7) 썸네일형 리스트형 [firebirdsql] read script file isql -q -i filename [firebirdsql] Autostart firebirdsql on centos 6 # Prerequisite# Already installed firebirdsql on OS. # to AutoStartcp /opt/firebird/misc/firebird.init.d.mandrake /etc/init.d/firebirdchmod 755 /etc/init.d/firebird then add the following line in /etc/rc.d/rc.local file/etc/init.d/firebird start [firebirdsql] Firebird Character Sets and Collations http://www.destructor.de/firebird/charsets.htm [firebirdsql] create database for windows installDir\bin\> isql -s 1 -ch KSC_5601SQL> create database 'c:\testdb.fdb' user 'usr1' password '87654321' page_size 8192 default character set KSC_5601;SQL> show db;Database: c:\testdb.fdb Owner: usr1PAGE_SIZE 8192Number of DB pages allocated = 164Sweep interval = 20000Forced Writes are ONTransaction - oldest = 1Transaction - oldest active = 2Transaction - oldest snapshot = 2Transa.. [firebirdsql] add user # for windows # Prerequisite- sysdba password 는 123456768- 생성할 유저 : usr1- 생성할 유저 비밀번호 : 87654321 installDir\bin> gsec -user sysdba -password 12345678GSEC> add usr1 -pw 87654321; or installDir\bin> gsec -user sysdba -pass masterkey -add usr1 -pw 87654321 [firebirdsql] to change sysdba password # Prerequisite- sysdba basic password id 'masterkey'- I'll try to change basic password to '12345678'. # firebirdsqlDir/bin>gsec -user sysdba -password masterkeyGSEC> modify sysdba -pw 12345678; or # firebirdsqlDir\bin> gsec -user sysdba -pass masterkey -mo sysdba -pw 12345678 # attention- FirebirdSql can recognize just 8 letters for passwords.- If you input over 8 letters, it just can recognize.. [firebirdsql] Install FirebirdSql # for windows installDir\bin>install_class.bat 이전 1 다음