Re: [PHP-DB] Backups, best practices
Beau Lebens wrote: // err.. please correct me if I'm wrong, but isn't pkzip // exactly that? or more // exactly, winzip is a windows interface to it? it certainly // uses the same // compression nope - you're right, i forgot about pkzip, but i was just saying that it's pretty strange that winzip is the biggest compression program used for windoze machines and they haven't released their own command-line version... last i heard it was still in the piplelines. and they probably never will... winzip took the opportunity that PKWARE didnt. winzip released a win interface to the ZIP compression scheme that Phil Katz wrote. and PKWARE never caught up to the popularity that winzip took. sadly, he died of alcoholic reasons. most people never knew him yet his code will live for a long time. trivia: the first two bytes of the any valid zip file? P and K... here's a frief history of the man: http://www.computeraddicts.com/pkzip.htm kinda sad, when i read in a PC MAG article a month or so ago when they celebrated 10 or so people that shaped the PC industry (or was influencial) in the last 20 years. one of persons is the porn king of the internet, and PK is left out... pkzip is made by a different company i think -- Leo G. Divinagracia III [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]
Re: [PHP-DB] Backups, best practices
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! err.. please correct me if I'm wrong, but isn't pkzip exactly that? or more exactly, winzip is a windows interface to it? it certainly uses the same compression 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 WindowsGood 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] -- 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]
RE: [PHP-DB] Backups, best practices
// 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! // // err.. please correct me if I'm wrong, but isn't pkzip // exactly that? or more // exactly, winzip is a windows interface to it? it certainly // uses the same // compression nope - you're right, i forgot about pkzip, but i was just saying that it's pretty strange that winzip is the biggest compression program used for windoze machines and they haven't released their own command-line version... last i heard it was still in the piplelines. pkzip is made by a different company i think -- 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]
Re: [PHP-DB] Backups, best practices
I use a script, written in Perl, that I run manually (but could be added to a cron tab): --- Starting of the script #!/usr/bin/perl print Starting...\n; ### Some variables $BASEDIR = /home/backup; $dump_path = /usr/bin/mysqldump; $date_path = /bin/date; # path to date $date_format = +%d%b%Y; # dateformat ddMonYear for file name $filedate = `$date_path $date_format`; chomp($filedate); $filedate =~ s/\s//g; # no spaces in there (like on the 1st of the month) # Dumping the databases print Dumping Databases...\n; exec mysqldump --all-databases --quick -uroot -p | gzip $BASEDIR/$filedate-MySQL.gz; print E finito!\n; --- End of the script This will ask you for the password of the user root (did you set this up? :) ) and pass the output to gzip that compress it. The final file is on the directory '/home/backup' and named '010101-MySQL.gz' (if you run the script the 1st of January of 2001). Of course, you could go further and do it progresively... This is quick and dirty, but it works! :) Regards, Tomás 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 +-- --+ Tomás García Ferrari Bigital http://bigital.com/ +-- --+ -- 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]
Re: [PHP-DB] Backups, best practices
try mysqldump - Original Message - From: Jacob Singh [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 06, 2001 10:22 PM Subject: [PHP-DB] Backups, best practices 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]
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 WindowsGood 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]