First page Back Continue Last page Overview Graphics
Types of Database Backups
Which to use?
Q: Which batabase backup method should you use?
A: First ask yourself these simple pre-requisite questions:
- Q: Do I require online backups?
- -If No: Use off line backups , dump, or hotcopy solution
- -If Yes: Ask next question:
- Q: Can I afford any interruption (even brief) in write access?
- -If Yes: Use dump, hotcopy, or snapshot solution
- -If No: Next...
- Q: Am I using InnoDB table types?
- -If Yes: Good, use ibback or snapshots for “hot backups”
- -If No: Convert to InnoDB table types w/ibback or snapshots