xuyuji9000/mysql-full-backup.sh

Last active August 11, 2017 08:14

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/xuyuji9000/0481060c62d3643c9a6466ce21b02859.js"></script>
Save xuyuji9000/0481060c62d3643c9a6466ce21b02859 to your computer and use it in GitHub Desktop.

Download ZIP

Make a full backup of a specific database in mysql

Raw

mysql-full-backup.sh

	#!/bin/bash

	DATABASE="forward"
	mysqldump -u mysqlusernamehere -pmysqlpasswordhere $DATABASE > /mnt/mysql/full/$(date +"%d-%b-%Y")_$(echo $DATABASE).sql

Author

xuyuji9000 commented Aug 11, 2017 •

edited

crontab cheetsheet

0 0 * * 0 /root/mydatabasebackupscript.sh

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment