EmpireKicking Posted April 16, 2016 Posted April 16, 2016 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 Posted April 16, 2016 Posted April 16, 2016 This might be of interest to you: https://sourceforge.net/projects/automysqlbackup/
EmpireKicking Posted April 17, 2016 Author Posted April 17, 2016 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 Posted April 17, 2016 Posted April 17, 2016 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 Posted April 21, 2016 Author Posted April 21, 2016 anyone! Code above is working but it's not backing up the full database
Recommended Posts
Archived
This topic is now archived and is closed to further replies.