{"id":585,"date":"2013-05-16T11:17:20","date_gmt":"2013-05-16T14:17:20","guid":{"rendered":"http:\/\/www.taioque.com.br\/?p=585"},"modified":"2014-02-05T21:58:11","modified_gmt":"2014-02-06T00:58:11","slug":"backup-banco-de-dados-mysql-separado-por-database","status":"publish","type":"post","link":"http:\/\/www.networktips.com.br\/?p=585","title":{"rendered":"Backup &#8211; Banco de dados MySql &#8211; Separado por Databases"},"content":{"rendered":"<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"http:\/\/static.hupso.com\/share\/buttons\/dot.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Linkedin\",\"Email\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"jorgeltaioque\";var hupso_url_t=\"\";var hupso_title_t=\"Backup%20-%20Banco%20de%20dados%20MySql%20-%20Separado%20por%20Databases\";<\/script><script type=\"text\/javascript\" src=\"http:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div><pre lang=\"php\" line=\"1\" escaped=\"true\">\r\n\r\n############################################\r\n# Backup do banco Mysql\r\n# Jorge Luiz Taioque\r\n#\r\n# Uso das v\u00e1riaveis\r\n#---------------------------\r\n# usuario - usuario do banco de dados\r\n# senha - senha do banco de dados\r\n# copias - quantidade de copias que devem ser guardadas\r\n# diretorio - diretorio que ficara salvo os bakcups\r\n#\r\n############################################\r\n\r\n#VARIAVEIS DO AMBIENTE\r\nusuario=root\r\nsenha=1234\r\ncopias=5\r\ndiretorio=\/home\/backup\r\n\r\nfind $diretorio -mtime +$copias > $diretorio\/old_backups.txt\r\n\r\nfind $diretorio -mtime +$copias -type f -exec rm -rf {} \\; \r\n\r\nmysql -u $usuario -p$senha -Bse 'show databases' > $diretorio\/databases.txt;\r\n\r\nmkdir $diretorio\/backup_databases;\r\n\r\ndata=$( date +%d-%m-%Y)\r\n\r\nfor i in $(cat $diretorio\/databases.txt); do\r\nif [ \"$i\" != \"information_schema\" ]\r\nthen\r\n\r\n    mysqldump -u $usuario -p$senha $i > $diretorio\/backup_databases\/$i-backup.sql;\r\n    \r\nfi\r\n\r\ndone\r\n\r\ntar zcvf $diretorio\/backup_mysql_$data.tar.gz $diretorio\/backup_databases;\r\n\r\nrm -r $diretorio\/databases.txt;\r\nrm -r $diretorio\/backup_databases;\r\n\r\n\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img src=\"http:\/\/static.hupso.com\/share\/buttons\/dot.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Linkedin\",\"Email\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"jorgeltaioque\";var hupso_url_t=\"\";var hupso_title_t=\"Backup%20-%20Banco%20de%20dados%20MySql%20-%20Separado%20por%20Databases\";<\/script><script type=\"text\/javascript\" src=\"http:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div><p>############################################ # Backup do banco Mysql # Jorge Luiz Taioque # # Uso das v\u00e1riaveis #&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212; # usuario &#8211; usuario do banco de dados # senha &#8211; senha do banco de dados # copias &#8211; quantidade de copias que devem &hellip; <a href=\"http:\/\/www.networktips.com.br\/?p=585\">Continue lendo <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"_links":{"self":[{"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=\/wp\/v2\/posts\/585"}],"collection":[{"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=585"}],"version-history":[{"count":4,"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=\/wp\/v2\/posts\/585\/revisions"}],"predecessor-version":[{"id":684,"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=\/wp\/v2\/posts\/585\/revisions\/684"}],"wp:attachment":[{"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=585"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=585"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.networktips.com.br\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=585"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}