{"id":1852,"date":"2019-04-06T15:58:33","date_gmt":"2019-04-06T20:58:33","guid":{"rendered":"http:\/\/creativapixel.com\/?p=1852"},"modified":"2019-04-06T16:04:35","modified_gmt":"2019-04-06T21:04:35","slug":"backup-automatico-de-mysql-en-centos","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/backup-automatico-de-mysql-en-centos\/","title":{"rendered":"Backup automatico de Mysql en CentOS"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Seguimos con la importancia de realizar un \nbackup peri\u00f3dicamente en nuestro servidor. En esta ocasi\u00f3n realizaremos \nel backup de una bd Mysql en CentOS con ayuda de un archivo sh y una \ntarea programada.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Primero creamos nuestro archivo backup.sh con permisos 777 en la ruta \/home\/admin\/backup y agregamos las siguientes lineas:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>FECHA_ACTUAL=`date +%Y-%m-%d`\nHORA_ACTUAL=`date +%H:%M`\nARCH_RESP=$FECHA_ACTUAL-$HORA_ACTUAL\n\nmysqldump --opt --password=tuClave --user=root nombreBd | gzip > \/home\/admin\/backup\/nombreBdbackup_$ARCH_RESP.sql.gz<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">guardamos y salimos de backup.sh<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ahora agregamos la tarea programada en CRON:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>crontab -e<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Agregamos las l\u00ednea:<br><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>0   13    *   *   *   \/home\/admin\/backup\/backup.sh<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">Esta l\u00ednea permite hacer un backup a las 13 hs con 00 minutos todos los dias de todos los meses de todos los a\u00f1os.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seguimos con la importancia de realizar un backup peri\u00f3dicamente en nuestro servidor. En esta ocasi\u00f3n realizaremos el backup de una bd Mysql en CentOS con ayuda de un archivo sh &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1854,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,38,32],"tags":[],"class_list":["post-1852","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-centos","category-mysql","category-seguridad"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1852","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/comments?post=1852"}],"version-history":[{"count":2,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1852\/revisions"}],"predecessor-version":[{"id":1855,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1852\/revisions\/1855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/1854"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=1852"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=1852"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=1852"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}