Restoring TeamCity Data from Backup

TeamCity allows administrator to restore previously Backing up TeamCity Data using the maintainDB command line utility.

note

Please note that restoration of the backup created by TeamCity can only be performed with the same TeamCity version that the backup file was created with.

To restore TeamCity server from previously saved backup file, run maintainDB utility with restore command and the name of desired backup file specified:

maintainDB[cmd|sh] restore -F <TeamCity backup file name>

maintainDB tool requires the path to the backup file to restore data from. By default, maintainDB looks for the specified file in the default backup directory: <TeamCity Data Directory>/backup. If the file is not found, the process will be aborted with an error. To override this setting, you can specify the absolute path to the desired backup file in a custom directory with the -A option.

By default, if no other option that -F is specified, all of the backed up scopes will be restored from the backup file. To restore only specific scopes from the backup file, use corresponding options of the maintainDB utility: -C, -D, -L, and -P. To get the reference for the available options of the maintainDB, run the utility without any command or option.

Restoring Data from Backup to Another Database



You can restore data into another empty database. Types of the source (from which the data is backed up) and target (to which the data will be restored) databases don't matter. For instance, you can restore data from a HSQL database to a MySQL database, as well as restore a backup of MySQL database to a new MySQL database. Essentially, restoring data from a backup file to another database is a migration process.

To restore database data to another database:

1. If you need to preserve properties of the target database, create new database.properties file from a template, which corresponds to the type of the target database, or copy the existing one to a temporary directory.

2. Run the maintainDB utility with restore command and -T option: maintainDB restore -F <backup file> -T <absolute path to the database.properties file of the target database> All backed up scopes will be restored and the database will be restored to a new one.

To restore database only, use the -D option.