Table Types & Consistency
• All tables need to flushed to disk
– FLUSH TABLES
• Tables can’t be updated during backup
– LOCK TABLES...
• Related tables treated as a group, lock all
– FLUSH TABLES WITH READ LOCK
• Transactional tables have logs to backup
Copyright 2002, Jeremy Zawodny (Jeremy@Zawodny.com)