RE: [PHP-DB] Backups, best practices
| From: | Beau Lebens | Date: | Fri, 07 Sep 2001 01:02:04 +0000 |
| Subject: | RE: [PHP-DB] Backups, best practices | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-12236@lists.php.net to get a copy of this message | ||
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:dan.brunner@duni.com]
// Sent: Friday, 7 September 2001 2:33 AM
// To: Jacob Singh
// Cc: php-db@lists.php.net
// 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:jsingh@balances.com
// >
// >
// > --
// > PHP Database Mailing List (http://www.php.net/)
// > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
// > For additional commands, e-mail: php-db-help@lists.php.net
// > To contact the list administrators, e-mail:
// php-list-admin@lists.php.net
// >
//
// --
// PHP Database Mailing List (http://www.php.net/)
// To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
// For additional commands, e-mail: php-db-help@lists.php.net
// To contact the list administrators, e-mail:
// php-list-admin@lists.php.net
//