{"id":65,"date":"2015-09-08T12:06:44","date_gmt":"2015-09-08T09:06:44","guid":{"rendered":"http:\/\/small-service.com\/?p=65"},"modified":"2016-03-09T12:27:56","modified_gmt":"2016-03-09T09:27:56","slug":"mysql_backup_by_db-sh","status":"publish","type":"post","link":"https:\/\/small-service.com\/?p=65","title":{"rendered":"mysql_backup_by_db.sh"},"content":{"rendered":"<pre>\r\n#!\/bin\/bash\r\n\r\nread -e -p \"Type host for backup, followed by [ENTER]: \" -i \"127.0.0.1\" host\r\nread -e -p \"Type username for $host, followed by [ENTER]: \" -i \"root\" user\r\nread -e -p  \"Type password for $user, followed by [ENTER]: \" -i \"\" passwd\r\nread -e -p  \"Database which should be backuped [ENTER]: \" -i \"all\" db\r\n\r\nDB_BACKUP=mysql_dump_$(date +%F)\r\n\r\nmkdir $DB_BACKUP  \r\ncd $DB_BACKUP\r\nif [ $db == \"all\" ] \r\nthen\r\n\tfor db in $(mysql  -h $host --user=$user --password=$passwd -e 'show databases' -s --skip-column-names|grep -viE '(staging|performance_schema|information_schema)'); do \r\n\t\tfile_name=\"mysqldump-$db-$(date +%Y-%m-%d).gz\";\r\n\t\tmysqldump -h $host --user=$user --password=$passwd --events  --log-error=mysql_dump.log --opt --single-transaction $db | gzip > $file_name;\r\n\t\t[ -s $file_name ] && res=Done || res=FAIL\r\n\t\techo $db\"|\"$file_name\"|\"$res\r\n\tdone | column -s \"|\" -t\r\nelse \r\n                file_name=\"mysqldump-$db-$(date +%Y-%m-%d).gz\";\r\n                mysqldump -h $host --user=$user --password=$passwd --events  --log-error=mysql_dump.log --opt --single-transaction $db | gzip > $file_name;\r\n                [ -s $file_name ] && res=Done || res=FAIL\r\n                echo $db\"|\"$file_name\"|\"$res\r\nfi        \t| column -s \"|\" -t\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash read -e -p &#8220;Type host for backup, followed by [ENTER]: &#8221; -i &#8220;127.0.0.1&#8221; host read -e -p &#8220;Type username for $host, followed by [ENTER]: &#8221; -i &#8220;root&#8221; user read -e -p &#8220;Type password for $user, followed by [ENTER]: &#8221; -i &#8220;&#8221; passwd read -e -p &#8220;Database which should be backuped [ENTER]: &#8221; -i &#8220;all&#8221; [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[15,34],"tags":[37,35,38,36],"_links":{"self":[{"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts\/65"}],"collection":[{"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=65"}],"version-history":[{"count":3,"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions"}],"predecessor-version":[{"id":80,"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts\/65\/revisions\/80"}],"wp:attachment":[{"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=65"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=65"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=65"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}