{"id":70,"date":"2015-09-08T13:22:08","date_gmt":"2015-09-08T10:22:08","guid":{"rendered":"http:\/\/small-service.com\/?p=70"},"modified":"2016-03-09T12:27:39","modified_gmt":"2016-03-09T09:27:39","slug":"mysql_restore-sh","status":"publish","type":"post","link":"https:\/\/small-service.com\/?p=70","title":{"rendered":"mysql_restore.sh"},"content":{"rendered":"<pre>\r\n#!\/bin\/bash\r\n\r\nfor i in `ls $1\/mysqldump*`; do\r\n    db=`sed -n -e 3p $i | awk -F \"Database: \" {'print $2'}`\r\n    mysql -e \"create database \\`$db\\`\"\r\n    echo `mysql -u root \"$db\" < $i`\r\n    echo \"created $db and filled from $i file\"\r\ndone\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash for i in `ls $1\/mysqldump*`; do db=`sed -n -e 3p $i | awk -F &#8220;Database: &#8221; {&#8216;print $2&#8217;}` mysql -e &#8220;create database \\`$db\\`&#8221; echo `mysql -u root &#8220;$db&#8221; < $i` echo \"created $db and filled from $i file\" done\n<\/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,39,40],"_links":{"self":[{"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts\/70"}],"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=70"}],"version-history":[{"count":6,"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":76,"href":"https:\/\/small-service.com\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions\/76"}],"wp:attachment":[{"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/small-service.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}