3 ms·
Time Machine makes backing up trivial to the extent that you have a sufficiently large HFS volume sitting around, and don't need to back up MySQL databases. A
by idlewords 17y ago
Time Machine makes backing up trivial to the extent that you have a sufficiently large HFS volume sitting around, and don't need to back up MySQL databases. And if you're unlucky, it can also automate the process of losing all your data:
http://tomkarpik.com/articles/massive-data-loss-bug-in-leopard/ http://tomkarpik.com/articles/massive-data-loss-bug-in-leopa...
http://rondam.blogspot.com/2009/09/time-machine-time-bomb.html http://rondam.blogspot.com/2009/09/time-machine-time-bomb.ht...
- glhaynes 17y agoWhat's the MySQL reference to? I haven't heard of a MySQL-specific issue with Time Machine.
- stilist 17y agoFor me, at least, every time I reinstalled Leopard and restored with Time Machine MySQL's data would be gone.
- inklesspen 17y agoWas your MySQL installation configured to store data in any of the excluded directories? http://shiftedbits.org/2007/10/31/time-machine-exclusions/ http://shiftedbits.org/2007/10/31/time-machine-exclusions/
- idlewords 17y agoIf I understand correctly, Time Machine takes a binary snapshot (similar to rsync). With MySQL (and InnoDB specifically) the stuff on disk is not guaranteed to be in a consistent state while the server is running. The safest way to back up mysql is mysqldump.