Shell scripting: Doing MySQL Dump base on date

Swakoo · 09-14-2005, 12:24 AM

i am doing regular mysqldump to backup databases daily.
the files are gzipped and store (via scp) into another server (let's call it server B)
filename format is
database_YYYY-mm-dd.sql.gzip

I want to write a shell script such that i can draw the data and at the same time, maintain only up to 7 days worth of data

I use $today=`date -I' to get the today's date format so can store in the file...

but to calculate today's date minus x no. of days?

hope its clear enough

Thanks mate!

rose_bud4201 · 09-14-2005, 04:46 PM

For today's date - x days, you can use the date command again (you're going to laugh

):

`date +'%Y-%m-%d' --date '7 days ago'`

Swakoo · 09-21-2005, 10:23 PM

wah serious!!!! hahahaha!