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

Notes: