First page Back Continue Last page Overview Graphics
Backup Agents and Tools 
	Raw: Snapshot Gotchas
- If backing up or scripting the backup of InnoDB table types, any snapshots are fine since the files on disk can always be considered consistent. 
- However,  when performing LVM/filesystem snapshots on My/ISAM tables, you must first issue a FLUSH TABLES WITH READ LOCKS before starting the snapshot and then an UNLOCK TABLES after the snapshot is complete:
- Any Snapshots with My/ISAM table types:
	FLUSH TABLES WITH READ LOCK
	-do snapshot here-
	UNLOCK TABLES
- After the snapshot is complete, then you can mount the snapshot and back it up to your backup media.
Notes: