I run mostly on windoze machines and have used a couple different ways, some
dodgy, some not so dodgy :)
1. you can use a batch file to copy the data dir from inside mysql (dodgy)
2. you can use the cgi of PHP to make a quick mysqldump script and execute
that
3. i *think* you should be able to use a batch file to just run the
mysqldump exe with some command line parameters (never tried - would be
nice)
you can get command line zip/compression packages for windows, although for
*some* reason, as far as i know, not a command line version of winzip - the
big one!
anywho, all of those should be able to be scheduled using the "at" command
from DOS (good old DOS... the closest a microsoft weenie will come to heaven
(*nix) :P)
HTH
Beau
// -----Original Message-----
// From: Dan Brunner [mailto:[EMAIL PROTECTED]]
// Sent: Friday, 7 September 2001 2:33 AM
// To: Jacob Singh
// Cc: [EMAIL PROTECTED]
// Subject: Re: [PHP-DB] Backups, best practices
//
//
// Hey Hey Hey!!!
//
// That depends on what system your running!?!?!?
//
// I run LinuxPPC and use 3 ways....
//
// 1. Bru Tape back system
//
// 2. At 12:00 AM the shell script runs and copies the files..
//
// 3. Once a month I manually copy the files to a zip.
//
//
// Dan
//
//
//
// PS Windows....Good luck.
//
//
// On Thursday, September 6, 2001, at 09:22 AM, Jacob Singh wrote:
//
// > Hello,
// >
// > I'm just wondering how everyone manages their MySQL backups, I'm
// > looking for a better solution than manual. any scripts
// or example
// > would be especially appreciated. tnks
// >
// > --
// > Best regards,
// > Jacob Singh
// > Pajama Design
// > (413)582-9342
// > 2 Belanger Pl.
// > Northampton, MA 01060
// >
// > mailto:[EMAIL PROTECTED]
// >
// >
// > --
// > PHP Database Mailing List (http://www.php.net/)
// > To unsubscribe, e-mail: [EMAIL PROTECTED]
// > For additional commands, e-mail: [EMAIL PROTECTED]
// > To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
// >
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: [EMAIL PROTECTED]
// For additional commands, e-mail: [EMAIL PROTECTED]
// To contact the list administrators, e-mail:
// [EMAIL PROTECTED]
//
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
