Due to a recent lose of one of my MYSQL databases, I have searched to have it automatically backed up. I have discovered this can be done by CRONJOB feature of Hostrocket. SILVERDOG wrote a msg http://forums.hostrocket.com/showthread.php?s=b85332a4e560a5ef44298131cd1b6ca9&threadid=3152&highlight=cronjob where he gives instructions (including php script to send database backups to you automatically through email via CRONJOB executing at a specified time.
This is excellent and is EXACTLY what I would like (CRONJOB automatically back up each of my database's, and email them to me nightly at 12 midnight). My question is this. HOW, if possible, can you make it so the file that is created (using CRONJOB to backup databases) is named a specific word and then ends with the current date? So to distinguish passed backups incase it is needing to be restored at any time. For example: TOP50LIST_05-30-02.SQL?
mysqldump -uusername -ppassword --database databasename > dailydump.sql
is the command line given in the email. But how to you replace the "dailydump.sql" for "TOP50LIST_[DD/MM/YY].SQL"?
Thanks Very Much
