Hi,

I have a linux machine at work which runs our intranet. Now, I need to be able to setup a cron job daily to back up the database. Now I have the command that successfully backs the database up, the only thing is this...

I run
"mysqldump --opt -u root -p intranet > /backup.sql
Enter password:"

It then moves the backup to my / folder.

Is it possible to:
1. Make it generate a filename in this format? HH:MM - DD/MM/YYYY
2. Setup the command in a daily cron job

+REP for any help, thanks!

Lew.