User Guide

14 Command-line tooL for database management 50
7signal Ltd, Panuntie 6, FI-00620 HELSINKI, FINLAND, [phone], [e-mail], www.7signal.com
7signal Sapphire Deployment Guide Release 3.0
14.3 Backup command group
Creates instant and automatic database backups.
NOTE: the backup policy should be well-planned. Please see the 7signal Sapphire
User Guide for further discussion on backup and the options available.
Backup commands:
show Show automatic backup configuration
remove Remove automatic backup configuration
set Configure automatic backup
o daily <HH:mm> <backup directory>
o weekly <DDD> <HH:mm> <backup directory>
<DDD> = Mon, Tue, Wed, etc.
o directory <backup directory>
Backup directory is optional if a backup
configuration already exists.
now Immediate backup.
o online
o offline
restore Recovery command
Examples
Remove configuration
# 7db backup remove
Backup every Wednesday at 00:30 to /mnt/backups
# 7db backup set weekly Wed 00:30 /mnt/backups
Backup every day at 03:00 to /mnt/backups
# 7db backup set daily 03:00 /mnt/backups
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
# 7db backup now offline
Restore a known-to-be-good system state