Removing files in a loop?

[matfish]

Hi again,

 

I have a script that runs on Cron which backs up my database every night with a filing format of: 2008_09_10.sql

I want to keep the last 30 days and remove everything previously. I was hoping to put this in a script kinda loop thing and run once a week to delete everything prior to the last 30 days.

 

Any ideas?

 

Many thanks

 

 

[Daniel0]

Try to add this to the end of the backup script:

find /path/to/files/*.sql -mtime +30 -exec rm -rf {} \;

[matfish]

Thanks for the reply.

 

I will give it a go and let you know.

 

Thanks again.

[Ghulam Yaseen]

Hello  ,

 

Alternatively, you can try this

 

rm -rf 2008_08_*.sql

 

the above will delete all sql files of 08th month

 

 

Hi again,

 

I have a script that runs on Cron which backs up my database every night with a filing format of: 2008_09_10.sql

I want to keep the last 30 days and remove everything previously. I was hoping to put this in a script kinda loop thing and run once a week to delete everything prior to the last 30 days.

 

Any ideas?

 

Many thanks