If you've got to make copies to disk then why not just maintain copies on disk via replication? Stop the slave, backup the slave, restart the slave.
-----Original Message----- From: Nicholas Stuart [mailto:[EMAIL PROTECTED]] Sent: Wednesday, July 31, 2002 8:55 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Backup automation.. Aye, I forgot to mention to lock the db before backing up...my bad. But again the idea is the same just schedule win2k to do it. -Nick Ed Carp said: >> >> On windows you could simply copy the entire data directory with a >> Scheduled job. Copying the files should be all you need to do for >> windows. >> >> For a cleaner, and what most people would say is a better way you >> could schedule a batch file to run mysqldump that would dump the >> data and structure to a file. >> >> mysqldump info can be found at: >> >> http://www.mysql.com/doc/m/y/mysqldump.html >> > >> >I hope you're shutting down MySQL before you do this. If yuo're not, >> your >> "backups" are probably worthless. > > sql, query > >> Shouldn't it be enough to lock the tables and FLUSH before doing the >> copy? I want to keep read access while doing the backup, and let >> writes queue (i.e. writers will find the database a bit soggy during >> backups, but read work OK and INSERT DELAYED will just be delayed - I >> hope. > > If you can guarantee that writes will not be propagated to the disk, you > may be all right. You might want to test to make sure you can ready > your backups, though - just in case. > > We use mysqldump here for backups - it's fast, gives us ASCII SQL files > to look at if something happens, and compresses well. I'd highly > recommend using it as opposed to copying the actual disk files around. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
