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.
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.
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.