Linux - Crontab

[cronoxhere]

Hi.. I'm trying to use crontab for a backup but I want it to execute a line dialy and save the log... I was trying something like this:

0 0 * * * line to execute here > file.sql

It works good, the problem is when it execute for second time, it just replace the file.sql.. so I was thinkinh in change the name to something like:

0 0 * * * line to execute here > day-month.sql

How can I do that?

 

[slaw]

use date command:

0 0 * * * line to execute here > `date +%d-%m-%y`.sql

 

[Red]

So how exactly would we do to make it mysqldump once a day?

Red

 

[Migxxx]

So how exactly would we do to make it mysqldump once a day?

Red

crontab -e

->

0 0 * * * /usr/bin/mysqldump --host="IP_ADDRESS" --user="USER_GOES_HERE" --password="AND_PASSWORD_HERE" --opt DATABASENAME 2>&1 > `date +%d-%m-%y`.sql

voilà!

For more info about setting it up, feel free to read this tutorial... (laziness>me lolz)
http://otland.net/f138/cronjob-crontab-auto-database-backup-72829/

 

[Red]

Thanks Migxxx. I'll let you know how it works tomorrow!

Red