I am also using win2k advanced server - what does the back-up syntax look like if I wanted to to it on Windows?
thanks Mark ----- Original Message ----- From: "Nicholas Stuart" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, July 31, 2002 8:54 AM 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. > > -- > > Ed Carp, N7EKG http://www.pobox.com/~erc > > 214/986-5870 Director, Software Development > > Escapade Server-Side Scripting Engine Development Team > > Pensacola - Dallas - London - Dresden > > http://www.squishedmosquito.com > > > > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
