Backup script using mysqlhotcopy question

[Troy Meyerink]

I am attempting to create a online backup script using the mysqlhotcopy command in version 4.1.8 on Linux Red Hat. My command looks like this:

$mysql_home/bin/mysqlhotcopy -u root -p=edcmysql mysql nukes $bkup_dir/hotbkup --flushlog --allowold > $bkup_dir/hotbkup/`hostname`.mysql.`date +%F`

where $mysql_home is my directory where mysql is installed and $bkup_dir is the directory where I am storing my backup files. I am trying to flush the logs and what I would like to do is write over my current backup files which is what I thought that the allowold would do. I store the backup log as the hostname.mysql.currentdate.

When I perform this from my cron job. the new backup log gets created and the mysql and nukes directories are changed to reflect the new date, but the files inside those directories do not change. I suspect that I am not getting a new copy of the tables. Can anyone show me the error of my ways? Thanks.

Troy Meyerink