Xopero can make a backup of Firebird database in versions 1.5.6 to 2.6 without the need to install additional components. Client application has to be installed on database server or on the machine, where the database file is stored in case of direct backup. To create a backup set, you need valid credentials to the database.
|During the preparation of Firebird database dump, the database is being compressed what will result in much smaller file than the database itself.|
Creating Backup set
To create the Firebird database backup set you need to open Xopero and run the Backup set wizard by clicking on New backup set button in My backup sets tab.
In the Backup set wizard mark Advanced copy and select Firebird from dropdown list. Don’t forget to define the backup set name.
In the Firebird section, parameters needed to connect with the database:
- Direct backup database file – if you select this option, a direct backup database file will be made - without the database server. Using this option requires entering path to a database file,
- Port – a port that the database is listening on. This field is inactive, when direct backup database file is selected,
- User – a Firebird user with proper rights,
- Password – a password for above user,
- Database name – name of the database that will be backed up. If direct backup database file option is checked, this field's name is changed to Path to database file, where you need to eneter full path to that file.
When all the fields are filled, you should click Test connection, which will start the automatic connection with the database test as well as it will verify the credentials. If any error is displayed, you should verify all the fields and restart the test. You also need to define location in field Temporary directory where the database dump will be stored for the time of backup. By clicking Save you will create a new backup set.
Restore of Firebird backup
The Restore process of Firebird database is a two-step process. First, you need to download the database backup to a local machine using Xopero application. In the second step, the database will be restored to a Firebird server using Firebird database management tools.
Restoring the database file from a backup
To download the Firebird database backup, run the Xopero application and go to the Restoring tab. All backed up databases will be available in the Firebird branch.
Expand the branch and mark the checkbox next to the database which has to be restored. Then click on the Restore selected button.
|To restore previous version of the database right click on its name and from context menu select Show file versions.|
The file restore settings window will be displayed. You have to select the location where a database backup file will be saved. From this directory it will also be restored to the Firebird database server.
Restoring database backup
To restore the downloaded file to a Firebird database server, you need to use a database management tool. Following instruction will use the FlameRobin Database Admin tool.
|You can download FlameRobin Database Admin tool from: http://www.flamerobin.org/.|
Restoring to an existing database
To restore database to an existing one, you need to open FlameRobin and connect with database server. You should see a list of available databases.
Right-click on the database, where the backup will be restored to and select Restore database…, from Actions menu. A window with restore settings should be displayed, where you should enter path to restored db file in Backup file field and check Replace existing database option.
The restore process starts after you click Start Restore Details can be seen in the white filed down the window. Successful restore should end with Database restore finished message.
Restoring to a new database
To restore the backup to a new database, connect with the database server using FlameRobin, and click Register existing database option from the Database, menu. A window with configuration for new database will be displayed.
Enter the name for new database in Display name filed as well as path to the new database file in Database path. Additionally, you need to set authentication. Click Save and set the configuration as decribed in Restore to an existing database.