«
»
1 Comment

Backup and Restore in Firebird [and Interbase] (but you knew that already)

2008
11.12

Always nifty to have it all in one spot :) Of course, this works for Interbase, too… all in the documentation.

Where dbserver = 127.0.0.1 (if it’s on localhost) and /databases/dbfile.fdb could be x:\DIR\FILE.[gdb|fdb] etc…

A “normal” Backup

?View Code BASH
gbak -v -t -user SYSDBA -password masterkey dbserver:/databases/dbfile.fdb c:\backups\dbfile.fbk

Backup with output to a logfile

?View Code BASH
del c:\backups\dbfile.log
gbak -v -t -user SYSDBA -password masterkey -y c:\backups\dbfile.log dbserver:/databases/dbfile.fdb c:\backups\dbfile.fbk

A “normal” Restore

?View Code BASH
gbak -c -v -user SYSDBA -password masterkey c:\backups\dbfile.fbk dbserver:/databases/dbfile2.fdb

Restore to an already existing database (Firebird 1.0, 1.5)

?View Code BASH
gbak -c -r -v -user SYSDBA -password masterkey c:\backups\dbfile.fbk dbserver:/databases/dbfile.fdb

Restore to an already existing database (Firebird 2.0)

?View Code BASH
gbak -r o -v -user SYSDBA -password masterkey c:\backups\dbfile.fbk dbserver:/databases/dbfile.fdb

Create a read-only database

?View Code BASH
gbak -c -v -mode read_only -use_all_space -user SYSDBA -password masterkey c:\backups\dbfile.fbk c:\files\dbfiledb.fdb

Tags: , , ,

This entry was posted on Wednesday, November 12th, 2008 at 13:26 and is filed under sysadmin. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “Backup and Restore in Firebird [and Interbase] (but you knew that already)”

  1. Firebird: DB auf Testsystem umziehen | .: o-o-s.de :. says:
    July 4, 2011 at 16:35

    [...] http://blog.sven.co.za/2008/11/12/backup-and-restore-in-firebird-and-interbase-but-you-knew-that-alr... [...]

Your Reply