Well, I’ve read the Help topic and gone through this again and again, but I cannot get a grip on backing up a Firebird database, or even finding the damn thing on my computer (Win XP).
Can anyone give a relatively DOS ignorant person a hand here? I want to get my FB database onto another (server) computer.
I see that the Server Administrator book has been announced and I’ve already got one on the way, but for now I’m just trying to manage my databases.
Thanks
Dave
There is a chapter in the Developer manual (the pdf online will be updated soon, the docs you get if you press F1 in the app have it) that describes how to backup databases.
If you use Firebird on the same platform you can simply copy the files.
Servoy’s own data is by default all stored in SERVOY.GDB, Servoy uses the repository_server connection (in preferences) that points to that database by default. By default that database is in the database directory in the main Servoy directory. To copy it to a different machine copy the database and place it wherever you want. IF the target machine is a different platform you will have to use the backup utility called gbak.
To make a backup (windows in this example):
c:\program files\firebird\bin\gbak -b -t -user sysdba -password masterkey dbname.gdb backupfile.bp (adjust path of gbak as necessary, I have added gbak to my path for convenience)
to restore: (mac in this example)
/Library/Frameworks/Firebird.framework/Resources/bin/gbak -r -user sysdba -password masterkey backupfile.bp dbname.gdb
/Library/Frameworks/Firebird.framework/Resources/bin
is the default path on mac where gbak sits
If you also want to backup your data or tables you created in a solution make a backup of the database you are storing that data in.
NOTE: the recommended way to transfer a solution from a developer box to a production box is to use the Repository export and import.