#!\/bin\/bash<\/p>\n
#Options##############
\nBKFOLDER=’\/.backup\/db’
\nDBHOST=’localhost’
\nDBUSER=’db_user’
\nDBPW=’db_password’
\nDBNAME=(\u00a0 ‘dbname’ )
\n#for all databases the user has access to, keep this uncommented:
\n#DBNAME=( `echo “show databases” |\u00a0 mysql –user=$DBUSER –password=$DBPW –host=$DBHOST\u00a0 | tail -n+3 `)<\/p>\n
#End Options #########<\/p>\n
echo “check if local .backups directory exists. if not create it”;
\nif [ ! -d “$BKFOLDER” ]; then
\nmkdir -p $BKFOLDER ;
\nfi<\/p>\n
echo “remove db files older than 6 day”;
\nfind $BKFOLDER\/*.tar.gz -type f -daystart -mtime +5 -exec rm {} \\;<\/p>\n
echo “get recent version of databases”;
\nfor i in “${DBNAME[@]}”
\ndo
\nFILENAME=$BKFOLDER\/$i-`date +\\%Y\\%m\\%d-\\%H\\%M\\%S`.sql
\nmysqldump –opt –user=$DBUSER –password=$DBPW –host=$DBHOST $i –lock-tables=false\u00a0\u00a0 > $FILENAME
\ntar -zcvf $FILENAME.tar.gz $FILENAME
\nrm $FILENAME
\ndone<\/p>\n
echo “all done!”<\/p>\n
#cron
\n#0 0 * * * \/.backup\/backupmysql.sh<\/p>\n","protected":false},"excerpt":{"rendered":"
#!\/bin\/bash #Options############## BKFOLDER=’\/.backup\/db’ DBHOST=’localhost’ DBUSER=’db_user’ DBPW=’db_password’ DBNAME=(\u00a0 ‘dbname’ ) #for all databases the user has access to, keep this uncommented: #DBNAME=( `echo “show databases” |\u00a0 mysql –user=$DBUSER –password=$DBPW –host=$DBHOST\u00a0 | tail -n+3 `) #End Options ######### echo “check if local .backups directory exists. if not create it”; if [ ! -d “$BKFOLDER” ]; then mkdir … Continue reading “Auto Backup MySQL Ubuntu”<\/span><\/a><\/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":[],"class_list":["post-68","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts\/68","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/comments?post=68"}],"version-history":[{"count":0,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/posts\/68\/revisions"}],"wp:attachment":[{"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/media?parent=68"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/categories?post=68"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prosindo.com\/blog\/wp-json\/wp\/v2\/tags?post=68"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}