mysqlbackup.sh question

hello,

really thanks the community for tutorial at:

http://www.howtoforge.com/back_up_mysql_dbs_without_interruptions

however i need to know how if i want to use this script to do backup every 3 hours and at the same time delete backup file which is older than 9 hours (3 backup version only need to be kept) ?

i can run the cronjob every 3 hours, but my remote backup server become full of backup since it only delete files older than 2 days.

please help.

thanks

 

Change this

Code:

for file in "$( /usr/bin/find /home/sqlbackup -type f -mtime +2 )"
do
  /bin/rm -f $file
done

To this

Code:

/usr/bin/find /home/sqlbackup -type f -mmin +540 -exec rm -vf {} \;