Learn how to restore your database and files from backups or snapshots.
Overview
Piglet Run supports multiple restore scenarios:
- Point-in-Time Recovery: Restore to any moment in time
- Full Restore: Restore from a complete backup
- Selective Restore: Restore specific databases or files
Quick Restore
Restore from the latest backup:
pig restore latest
Restore Database
List Available Backups
pig backup list
Restore Full Backup
pig restore db --backup 2024-01-15
Point-in-Time Recovery
pig restore db --time "2024-01-15 14:30:00"
Restore Specific Database
pig restore db mydb --backup 2024-01-15
Restore Files
Restore All Files
pig restore files --backup 2024-01-15
Restore Specific Directory
pig restore files /home/dba/projects --backup 2024-01-15
Restore from Snapshot
pig snapshot restore snap-20240115
Verification
After restore, verify data integrity:
pig verify db
pig verify files