Tilted Forum Project Discussion Community - View Single Post

asshopo · 06-08-2005, 05:40 AM

Something like (call this file backup.sh):

Code:

#!/bin/bash

#Get current date
TODAY=$(date +%Y%m%d)

mysqldump --all-databases -u <YOURUSERNAMEHERE> --password=<YOURPWDHERE> -r /path/to/backup/directory/mysql-backup_$TODAY.sql

exit 0

And then enter a cron entry like:

Code:

00 1 * * * <YOURSYSTEMUSERNAMEHERE> /path/to/backup.sh

To run the script at 1am, everyday.

06-08-2005, 05:40 AM	#5 (permalink)
asshopo Insane Location: Michigan	Something like (call this file backup.sh): Code: #!/bin/bash #Get current date TODAY=$(date +%Y%m%d) mysqldump --all-databases -u <YOURUSERNAMEHERE> --password=<YOURPWDHERE> -r /path/to/backup/directory/mysql-backup_$TODAY.sql exit 0 And then enter a cron entry like: Code: 00 1 * * * <YOURSYSTEMUSERNAMEHERE> /path/to/backup.sh To run the script at 1am, everyday. __________________ Patterns have a habit of repeating themselves.