User Guide

11 Command-line tool for database management 71
7signal Solutions Inc., 526 S. Main Street, Akron, Ohio 44311, USA, 855-763-9526, [e-mail],
www.7signal.com
7signal Sapphire Deployment Guide Release 5.0
 restore Recovery command
 workdir Configure working directory used in backup and restore operations.
Examples:
Remove configuration
# 7db backup remove
Backup offline every Wednesday at 00:30 to /mnt/backups
# 7db backup set weekly Wed 00:30 /mnt/backups offline
Backup online every day at 03:00 to /mnt/backups
# 7db backup set daily 03:00 /mnt/backups online
Change backup directory to /mnt/newbackups, do not change time settings
# 7db backup set directory /mnt/newbackups
Backup every Sunday at 00:30, do not change backup directory
# 7db backup set weekly Sun 01:30
Back the system up immediately offline
# 7db backup now /mnt/backups offline
Back the system up immediately online (requires archival database logging)
# 7db backup now /mnt/backups online
Set working directory for backup and restore (highly recommended for larger databases)
# 7db backup workdir set /opt/largefilesystem
Restore a known-to-be-good system state
# 7db backup restore <backup-file>
11.3 Show command group
Shows the status and configuration of the database
Show commands:
 tabstatus Show the status of the tables.
o all
o <database_name>
 conf Show configuration of the database.
Examples
Show status of the tables in the MEAS7 and MGMT7 databases