Skip to content

Restore

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

Next Steps