Re: dbnightly maintenance backup script

2007-05-16 Thread Ofer Inbar
On Thu, May 10, 2007 at 03:23:31PM -0400, Ofer Inbar [EMAIL PROTECTED] wrote: http://thwip.sysadmin.org/dbnightly The version I put up there had a minor bug: 176c176 my ($sec,$min,$hour,$mday,$mon,$year) = localtime(time); $year+=1900; --- my ($sec,$min,$hour,$mday,$mon,$year) =

dbnightly maintenance backup script

2007-05-10 Thread Ofer Inbar
I wrote a perl script to handle all of our regular mysql maintenance tasks, which I thought might be useful to others. It's meant for an enviroment with binary logging turned on, but is fairly flexible. Although if you're backing up multiple databases you'll have to modify it a bit, since in our

RE: dbnightly maintenance backup script

2007-05-10 Thread Daevid Vincent
- From: Ofer Inbar [mailto:[EMAIL PROTECTED] Sent: Thursday, May 10, 2007 12:24 PM To: mysql@lists.mysql.com Subject: dbnightly maintenance backup script I wrote a perl script to handle all of our regular mysql maintenance tasks, which I thought might be useful to others. It's meant