#! \/bin\/bash<\/p>\n
<\/p>\n
# your MySQL server\u2019s name
\nSERVER=test.net<\/p>\n
# directory to backup to
\nBACKDIR=~\/backups<\/p>\n
# date format that is appended to filename
\nDATE=`date +\u2019%m-%d-%Y\u2019`<\/p>\n
#\u2014\u2014\u2014\u2014\u2014\u2014\u2014-MySQL Settings\u2014\u2014\u2014\u2014\u2014\u2014\u2013#<\/p>\n
# your MySQL server\u2019s location (IP address is best)
\nHOST=localhost<\/p>\n
# MySQL username
\nUSER=username<\/p>\n
# MySQL password
\nPASS=password<\/p>\n
# List all of the MySQL databases that you want to backup in here,
\n# each separated by a space
\nDBS=\u201ddb1 db2?<\/p>\n
# set to \u2018y\u2019 if you want to backup all your databases. this will override
\n# the database selection above.
\nDUMPALL=y<\/p>\n
#\u2014\u2014\u2014\u2014\u2014\u2014\u2014-Mail Settings\u2014\u2014\u2014\u2014\u2014\u2014\u2013#<\/p>\n
# set to \u2018y\u2019 if you\u2019d like to be emailed the backup (requires mutt)
\nMAIL=y<\/p>\n
# email addresses to send backups to, separated by a space
\nEMAILS=\u201d1@gmail.com 2@inbox.com 3@goowy.com\u201d<\/p>\n
SUBJECT=\u201dMySQL backup on $SERVER ($DATE)\u201d<\/p>\n
#\u2014\u2014\u2014\u2014\u2014\u2014\u2014-FTP Settings\u2014\u2014\u2014\u2014\u2014\u2014\u2013#<\/p>\n
# set \u201cFTP=y\u201d if you want to enable FTP backups
\nFTP=n<\/p>\n
# FTP server settings; should be self-explanatory
\nFTPHOST=\u201dftp.server.com\u201d
\nFTPUSER=\u201dusername\u201d
\nFTPPASS=\u201dpass\u201d<\/p>\n
# directory to backup to. if it doesn\u2019t exist, file will be uploaded to
\n# first logged-in directory
\nFTPDIR=\u201dbackups\u201d<\/p>\n
#\u2014\u2014\u2014\u2014\u2014\u2014-Deletion Settings\u2014\u2014\u2014\u2014\u2014\u2014-#<\/p>\n
# delete old files?
\nDELETE=y<\/p>\n
# how many days of backups do you want to keep?
\nDAYS=3<\/p>\n
#\u2014\u2014\u2014\u2014\u2014\u2014\u2014-End of Settings\u2014\u2014\u2014\u2014\u2014\u2014#<\/p>\n
# check of the backup directory exists
\n# if not, create it
\nif [ -e $BACKDIR ]
\nthen
\necho Backups directory already exists
\nelse
\nmkdir $BACKDIR
\nfi<\/p>\n
if [ $DUMPALL = “y” ]
\nthen
\necho \u201cCreating list of all your databases\u2026\u201d<\/p>\n
mysql -h $HOST \u2013user=$USER \u2013password=$PASS -e \u201cshow databases;\u201d > dbs_on_$SERVER.txt<\/p>\n
# redefine list of databases to be backed up
\nDBS=`sed -e \u2018:a;N;$!ba;s\/\\\\n\/ \/g\u2019 -e \u2018s\/Database \/\/g\u2019 dbs_on_$SERVER.txt`
\nfi<\/p>\n
echo \u201cBacking up MySQL databases\u2026\u201d
\nfor database in $DBS
\ndo
\nmysqldump -h $HOST \u2013user=$USER \u2013password=$PASS $database > \\\\
\n$BACKDIR\/$SERVER-mysqlbackup-$database-$DATE.sql
\ngzip -f -9 $BACKDIR\/$SERVER-mysqlbackup-$database-$DATE.sql
\ndone<\/p>\n
# if you have the mail program \u2018mutt\u2019 installed on
\n# your server, this script will have mutt attach the backup
\n# and send it to the email addresses in $EMAILS<\/p>\n
if [ $MAIL = “y” ]
\nthen
\nBODY=\u201dYour backup is ready! Find more useful scripts and info at http:\/\/www.ameir.net\u201d
\nATTACH=`for file in $BACKDIR\/*$DATE.sql.gz; do echo -n \u201c-a ${file} \u201c; done`<\/p>\n
echo \u201c$BODY\u201d | mutt -s \u201c$SUBJECT\u201d $ATTACH $EMAILS<\/p>\n
echo -e \u201cYour backup has been emailed to you! \\n\u201d
\nfi<\/p>\n
if [ $FTP = “y” ]
\nthen
\necho \u201cInitiating FTP connection\u2026\u201d
\ncd $BACKDIR
\nATTACH=`for file in *$DATE.sql.gz; do echo -n -e \u201cput ${file}\\n\u201d; done`<\/p>\n
ftp -nv < open $FTPHOST
\nuser $FTPUSER $FTPPASS
\ncd $FTPDIR
\n$ATTACH
\nquit
\nEOF
\necho -e \u201cFTP transfer complete! \\n\u201d
\nfi<\/p>\n
if [ $DELETE = “y” ]
\nthen
\nfind $BACKDIR -name \u201c*.sql.gz\u201d -mtime $DAYS -exec rm {} \\\\;<\/p>\n
if [ $DAYS = “1” ]
\nthen
\necho \u201cYesterday\u2019s backup has been deleted.\u201d
\nelse
\necho \u201cThe backup from $DAYS days ago has been deleted.\u201d
\nfi
\nfi<\/p>\n","protected":false},"excerpt":{"rendered":"
#! \/bin\/bash<\/p>\n
<\/p>\n
# your MySQL server\u2019s name SERVER=test.net<\/p>\n
# directory to backup to BACKDIR=~\/backups<\/p>\n
# date format that is appended to filename DATE=`date +\u2019%m-%d-%Y\u2019`<\/p>\n
#\u2014\u2014\u2014\u2014\u2014\u2014\u2014-MySQL Settings\u2014\u2014\u2014\u2014\u2014\u2014\u2013#<\/p>\n
# your MySQL server\u2019s location (IP address is best) HOST=localhost<\/p>\n
# MySQL username USER=username<\/p>\n
# MySQL password PASS=password<\/p>\n
# List all of the MySQL databases that you want […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2191"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2191"}],"version-history":[{"count":3,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2191\/revisions"}],"predecessor-version":[{"id":2194,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2191\/revisions\/2194"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}