First page Back Continue Last page Overview Graphics
Types of Database Backups
Raw Backup Types
Raw backups work by grabbing the DB files at the binary filesystem level. Hot online raw backups are done by locking, flushing, and cloning the DB files in some way, or via LVM/snapshots. Warm onlines are done by breaking a replicated slave and backing it up. Cold off line backups are done by simply shutting off the DB and copying.
Raw Pros:
Faster: since working at the filesystem level
Hefty: can handle larger databases
Powerful: Can be implemented with online LVM snapshots
Friendly: to most table types and normalized designs
Raw Cons:
Limited: to in place restores or same DB table/ver. migrations
Static: Backups are not as easily editable or customizable
Notes: