using bash in cron to get the date in filename

rstoutmna · 12-29-2004, 12:43 PM

Can anyone help me with a mysqldump to a windows share that will allow me to save the name of the file as the current date using cron? It will dump to a file with a static name but I would rather it not write over a previous file. Thanks.

Hko · 12-29-2004, 02:39 PM

Code:

#!/bin/bash

DUMPFILE="mysqldump_$(date '+%Y-%m-%d').sql"
mysqldump --opt --databases "YourDatabaseName" >"$DUMPFILE"

Read "man date" for more options on the format of the date. I used "<year>-<month>-<day>" here because that'll sort better.