How to delete old MySQL backup files

[Proware]

I have set up MySQL to backup the Sugar database dailyto a server folder..
Each backup is over 4GB so it quickly eats up disk space.
I am using my system backup to then back these up on to offline storage.

How can I configure MySQL to only keep the last week's worth of backups?

[roblaus]

Hi,

I'm using Webmin and there you have a possibility to define commands to be run before/after each or all mysql backups. I never tried it but it should be easy to set up something there.

The standard way - set up a cron job that cleans up after the backup has run.

rgds
rl

[kuske]

In WIn2003 I would use a little vbs - Script started by windows scheduler evey day.
In ths script you can request the day of the week an move your backup to a directory with the weekdays name or number.