Creating a database backup on Reporter using CLI

Products

• Reporter
• Reporter-VA

Issue/Introduction

Reporter allows Administrators to back up databases. This operation can be done from the Manage Backups interface or the CLI command terminal.  Administrators using Reporter 10.6 and later should use the Manage Backups feature in the web UI.

Environment

Reporter 10.x 

Reporter 11.x

Resolution

Creating a database backup using Command Line Interface (CLI)

The following instructions are for creating a new database backup from the CLI command terminal. The Reporter must be stopped before creating a stable backup when using the command line.

1. In the CLI enter enable mode.
2. Type stop-reporter
3. To see the current list of databases for which you can create a backup, enter dbbackup list create
4. Type dbbackup create <database index number>
5. Enter y to confirm the backup creation.

Warning: After the backup process begins do not attempt to interrupt it by pressing Ctrl+C. As of Reporter 10.6, if you interrupt a backup it will enter the "busy" state but will never complete. The only way to recover is to restart the appliance (not just the Reporter).  After the Reporter is back online, the backup will be in a Failed state, and you can either update or
delete it.

 

Restoring from a database backup

Follow these instructions to restore a database from backup. A database cannot be restored from the command line if the Reporter is online.

1. In the CLI enter enable mode.
2. Type stop-reporter
3. To see the current list of backups that can be restored to databases, enter dbbackup list restore
4. Type dbbackup restore <backup index number>
5. Enter y to confirm the restoration from backup.

 

Deleting a database backup

To free up disk space you can delete older backups. You cannot delete a backup if Reporter is online.

Warning: Deleting a backup is permanent. You cannot undo this action.

 

1. In the CLI enter enable mode.
2. Type stop-reporter
3. To see the current list of database backups that can be deleted, enter dbbackup list delete
4. Type dbbackup delete <backup index number>
5. Enter y to confirm the deletion.