Backup and Restore

An important part of database administration is to make regular backups of your database. Database Backup and Restore functions are available via the inoadmin commandline tool. The backup command makes a copy of the database. The restore command restores the database to the state it was in when you made the backup. Restore is generally executed together with a Recover process, in which all changes that were made to the database after the backup are re-applied. During the Recover process, log files (log spaces) that record all completed database transactions that have occurred since the most recent backup are used as input files. In this way, all data up to the most recently completed transaction can be restored.


Backup

To create a backup use the inoadmin backup command.

graphics/inoadmin_backup.png

If no location is provided the backup is stored at the initial location. The database to be backed up needs to be started.

graphics/inoadmin_backup_mydb.png

The inoadmin listbackups command shows all currently existing backups of a database.

graphics/inoadmin_listbackups.png

So, having backed up the database the new backup appears as a result of the inoadmin listbackups command.

graphics/inoadmin_listbackups_mydb.png

Besides the new backup there is allways the initial backup that is created with the database itself.

Restore and Recover

The inoadmin restore command allows to restore the database to a previous state or to the actual state in case of failure.

graphics/inoadmin_restore.png

To restore and recover a database from a backup the database must be down. Just issuing the command with <dbname> as the only parameter re-establishes the database by using the latest backup and applies all modifications stored in the log files.

graphics/inoadmin_restore_mydb.png