### siehe auch ### http://www.statconsult.de/download/firebird/ ### ( fuer downloads etc. ) DUMP ====== gbak.exe -backup -user sysdba -password masterkey -verify -y C:\palliDOC\database\db-dump-log.txt C:\palliDOC\database\DATA.FDB C:\palliDOC\database\db-dump.sql gbak.exe -backup -user sysdba -password masterkey -verify -y C:\palliDOC\database\db-dump-log.txt localhost/3050:C:\palliDOC\database\DATA.FDB C:\palliDOC\database\db-dump.sql gbak.exe -se localhost/3050:service_mgr -backup -user sysdba -password masterkey -verify -y C:\palliDOC\database\db-dump-log.txt C:\palliDOC\database\DATA.FDB C:\palliDOC\database\db-dump.sql gbak.exe -se localhost/3051:service_mgr -backup -user sysdba -password masterkey -verify -y C:\palliDOC_2\database\db-dump-log.txt C:\palliDOC_2\database\DATA.FDB C:\palliDOC_2\database\db-dump.sql RESTORE ======= gbak.exe -recreate -user sysdba -password masterkey -verify -y C:\palliDOC\database\db-restore-log.txt C:\palliDOC\database\db-dump.sql C:\palliDOC\database\DATA.FDB gbak.exe -recreate -user sysdba -password masterkey -verify -y C:\palliDOC\database\db-restore-log.txt C:\palliDOC\database\db-dump.sql localhost/3050:C:\palliDOC\database\DATA.FDB gbak.exe -se localhost/3050:service_mgr -recreate -user sysdba -password masterkey -verify -y C:\palliDOC\database\db-restore-log.txt C:\palliDOC\database\db-dump.sql C:\palliDOC\database\DATA.FDB gbak.exe -se localhost/3051:service_mgr -recreate -user sysdba -password masterkey -verify -y C:\palliDOC_2\database\db-restore-log.txt C:\palliDOC_2\database\db-dump.sql C:\palliDOC_2\database\DATA.FDB CREATE ========= isql.exe [to enter shell mode] create database 'C:\palliDOC\database\DATA.FDB' page_size 8192 user 'sysdba' password 'masterkey'; exit; NOTES ========= Q: weird messages ala \\ can't format message 12:169 -- message system code 4 \\ A: set FIREBIRD_MSG=C:\palliDOC\firebird_sc [or remove registry key -> HKEY_LOCAL_MACHINE\SOFTWARE\Firebird Project\Firebird Server\Instances ] Q: http://tracker.firebirdsql.org/browse/CORE-4050 [ Error when we try restore an backup using Gbak 2.5.2.26540 and FB 2.0 + gbak: ERROR:Dynamic SQL Error ] A: run backup/restore through the appropriate service_mgr for this installation