@manhng

Welcome to my blog!

How to backup/restore a Firebird database?

May 19, 2021 16:31

How to backup/restore a Firebird database? (edit)

How to backup/restore a Firebird database? - Stack Overflow

**********************************************************************
** Visual Studio 2019 Developer Command Prompt v16.9.4
** Copyright (c) 2021 Microsoft Corporation
**********************************************************************

C:\Windows\System32>C:

C:\>cd "C:\Program Files\Firebird\Firebird_3_0\"

C:\Program Files\Firebird\Firebird_3_0>gbak -c -user SYSDBA -password masterkey C:\Git\DB\Test.bak C:\Git\DB\Test.fdb

C:\Program Files\Firebird\Firebird_3_0>

Connection String

<connectionStrings>
<add name="TestContext" connectionString="character set=none; data source=localhost;initial catalog=Test; port number=3050; user id=sysdba; dialect=3; password=masterkey;Max Pool Size=1000" providerName="FirebirdSql.Data.FirebirdClient" />
</connectionStrings>

Test DB Connection (DBeaver 21.0.0)

C:\>cd "C:\Program Files\Firebird\Firebird_3_0\"

C:\Program Files\Firebird\Firebird_3_0>Notepad++ databases.conf

# ------------------------------
# List of known databases
# ------------------------------

#
# Makes it possible to specify per-database configuration parameters.
# See the list of them and description on file firebird.conf.
# To place that parameters in this file add them in curly braces
# after "alias = /path/to/database.fdb" line. Example:
# big = /databases/bigdb.fdb
# {
# LockMemSize = 32M # We know that bigdb needs a lot of locks
# LockHashSlots = 19927 # and big enough hash table for them
# }
#

#
# Example Database:
#
employee.fdb = $(dir_sampleDb)/employee.fdb
employee = $(dir_sampleDb)/employee.fdb


test = C:/Git/DB/Test.FDB

#
# Master security database specific setup.
# Do not remove it until you understand well what are you doing!
#
security.db = $(dir_secDb)/security3.fdb
{
RemoteAccess = false
DefaultDbCachePages = 50
}

#
# Live Databases:
#

Result is

 

Categories

Recent posts