#!/usr/bin/perl

use strict;

my $hostname = $ARGV[0];
my $partition = $ARGV[1];
my $backupdir = "non-user-mysql";
my $numcopiestokeep = 31;
my $mysqldumpesmode = 0600;

if ( !-d "/home/$hostname/$partition/$backupdir" ) {
  die "/home/$hostname/$partition/$backupdir not found.  Exiting\n";
}

my @dbs = ();
opendir(DIR, "/home/$hostname/$partition/$backupdir/");
foreach my $file ( readdir DIR ) {
  chomp $file;
  next unless ($file =~ m/^([\w\-\_]+)\.0\.sql$/);
  push @dbs, $1;
}
closedir DIR;

#dump each database
foreach my $db (@dbs){
  print "Rotating $db...\n";
  my $n = $numcopiestokeep;
  while ($n > 0){
    if(-f "/home/$hostname/$partition/$backupdir/$db.$n.sql"){
      unlink("/home/$hostname/$partition/$backupdir/$db.$n.sql");
    }
    my $n2 = $n - 1;
    if(-f "/home/$hostname/$partition/$backupdir/$db.$n2.sql"){
      rename("/home/$hostname/$partition/$backupdir/$db.$n2.sql", "/home/$hostname/$partition/$backupdir/$db.$n.sql");
      chmod $mysqldumpesmode, "/home/$hostname/$partition/$backupdir/$db.$n.sql";
    }
    $n--;
  }
  chmod $mysqldumpesmode, "/home/$hostname/$partition/$backupdir/$db.$n.sql";
}
