Setting Backup Cron Job (MySQL)

[EmpireKicking]

I'm needed help on setting up an Cron job, I know how Cron works and how to add it but I seem that I can't get the code right and it's not doing what I wanted it to do. I explain what I am after.

-I want to set up an cron job so that every 24 hours (a day) MYSQL gets backed up into my folder on the server.
-I want the cron to be setup so that it keeps the backups for 7 days before it gets removed, so should be around 7 MYSQL backup files in the backup folder. 

This is what I have so fair that does work but doesn't back up the full amount in folder

mysqldump -uNAME -PASSWORD >/home/*****/backups/database_dump.sql

Every day it backup the following, and not the full MYSQL which is 500 or so MB

Usage: mysqldump [OPTIONS] database [tables]
OR     mysqldump [OPTIONS] --databases [OPTIONS] DB1 [DB2 DB3...]
OR     mysqldump [OPTIONS] --all-databases [OPTIONS]
For more options, use mysqldump --help

 

[sudo]

This might be of interest to you: https://sourceforge.net/projects/automysqlbackup/

[EmpireKicking]

9 hours ago, ZeroHour said:

This might be of interest to you: https://sourceforge.net/projects/automysqlbackup/

I Check that out later, have anyone tried this? Also is the automatic install safe to use?

[sudo]

16 hours ago, EmpireKickAss said:

I Check that out later, have anyone tried this? Also is the automatic install safe to use?

I used to use that script ages ago but not in the last year or so as we have AWS backing it up for us now.

[EmpireKicking]

anyone! Code above is working but it's not backing up the full database