On Sun, Dec 14, 2003 at 02:08:07PM +1100, Chris Nolan wrote: > Hi! > > Thanks for the detailed reply! > > Regarding the hot backup method that the other guys use, sounds like a > dodgy method of doing anything to be honest. It would have to have a > fairly decent performance hit...
It's going to have a performance hit, sure. That's a lot of disk I/O to be doing. As for as being dodgy, I don't think so. They know the internals of their systems and have a provden technique for making usable backups. SUre, it's different but that doesn't mean it's bad. > Regarding the rollback of ALTER, DROP and RENAME statements, the main > use that I've seen for it is upgrades of custom software. It's handy > should an ALTER TABLE fail or similar. That's the sole reason that one > developer I know of deploys SQLBase to their clients. Yeah, if you've ever accidentally done a DROP TABLE on the wrong database, you know why it's useful to be able to roll 'em back. :-( Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
