denverpilot
Tied Down
Next time that happens let me know. I've been down that road many times. Why did you have to shut it down for 12 hours to get a dump? If you're using InnoDB you can just dump in a single transaction without causing any real locking issues: --single-transaction option on mysqldump. Filesystem snapshot works very well with InnoDB as well and can be trusted. If you're really concerned you can do a flush tables with read lock; and then snapshot quickly and unlock tables.
Heh. Wasn't my project. If you recall from our in-person discussions, it was that stupid e-mail DB that shouldn't be in an RDBMS anyway.




)