Cron Jobs

Technical IT / Communications
1

I need to make a cron job that will delete all of the files out of a directory and backup my mysql database, then delete the old backup every night at 12 AM.

I have been searching for some good tutorials but they all seem to rely on knowing UNIX, which I haven’t the slightest… If anyone could help me out, that would be great. :slight_smile:

2

I do something like this for sql server backups, to delete a file you will have to add the appropriate “rm” command for your files

10 0 * * * cd /home/me/backups; /usr/bin/mysqldump --opt -u DBUSER -pDBPASS DBNAME > databasefile.sql

Here are a couple references for cron jobs,
http://www.linuxhelp.net/guides/cron/

3

Thanks alot!