jak119/mysql_backup.sh

## mysql_backup.sh
#!/bin/bash
#@author Jamison Kissh
#Schedule the job to run via a cron job

#edit line below to include password after -p
mysqldump -u root -p --all-databases | gzip > ./database`date +%F_%T`.sql.gz

#Remove backups older than five days
find ./database* -mtime +5 -exec rm {} \;
	#!/bin/bash
	#@author Jamison Kissh
	#Schedule the job to run via a cron job

	#edit line below to include password after -p
	mysqldump -u root -p --all-databases \| gzip > ./database`date +%F_%T`.sql.gz

	#Remove backups older than five days
	find ./database* -mtime +5 -exec rm {} \;