Perl/mysql/Cron problem

[gregg R Allen]

I am running the following under Mac OS X (10.2) and it runs fine
interactively,  but it makes the directory and then quits when run as
a cron job.

Any ideas?

Thanks in advance,


Gregg Allen


###################################################################### #
#################



#!/usr/bin/perl -w

use POSIX;

use strict;



my $dat = `date +%Y-%m-%d`;


$dat =~ s/\s+//g;


my $command = "mkdir /archive/mysql/$dat";

my $result = system(" $command ");


my $command2 = "mysqlhotcopy --allowold --user=root

--password=rootpassword clients /archive/mysql/$dat " ;

my $res = system(" $command2 ");



my $comm = "gzip /archive/mysql/$dat/clients/*.*";


my $result2 = system(" $comm ");



exit 0;