So - I’m working on making a nice little shell script to dump mysql databases and then roll them up into a tar ball and ship them off to a web-accessable directrory.
I have a mysql dump working, but I would like it to create a file with the current date in it - like mysql.date.sql I read in the K-base in one of the user posts to
mysqldump… > filename.
but when I do it simply puts out filename.date+%y%m%d. Can any one tell me what I should do?
I have created a simple text file with pico via SSH and named it backup.sh. It’s stored behind the web-accessable area and I set CHMOD to 700. My idea is to set up this script, and then once all is working the way I want - set up a cron job to excute this script once a week.