{"id":1680,"date":"2018-07-08T12:09:12","date_gmt":"2018-07-08T17:09:12","guid":{"rendered":"http:\/\/creativapixel.com\/?p=1680"},"modified":"2018-08-18T00:23:24","modified_gmt":"2018-08-18T05:23:24","slug":"backup-mysql-con-cronjob-en-cpanel-hosting","status":"publish","type":"post","link":"https:\/\/creativapixel.com\/blog\/backup-mysql-con-cronjob-en-cpanel-hosting\/","title":{"rendered":"Backup MySQL con cronjob en cpanel hosting"},"content":{"rendered":"<p>En este art\u00edculo aprenderemos a crear un backup a nuestra base de datos mysql y almacenarlo en una carpeta en nuestra cuenta de hosting haciendo uso de una tarea programada para automatizar este proceso.<\/p>\n<p>Primero ingresamos al cpanel de nuestra cuenta de hosting y creamos una carpeta donde guardaremos nuestros respaldos de base de daros. Por ejemplo creare una carpeta \u00abbackup_bd\u00bb en public_html.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1681\" src=\"http:\/\/creativapixel.com\/wp-content\/uploads\/2018\/07\/cpanel_m.png\" alt=\"\" width=\"448\" height=\"188\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/cpanel_m.png 448w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/cpanel_m-300x126.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n<p>Luego en nuestro panel ingresamos a \u00abTrabajos de cron\u00bb para registrar una tarea programada<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1682\" src=\"http:\/\/creativapixel.com\/wp-content\/uploads\/2018\/07\/cronjob_m.png\" alt=\"\" width=\"448\" height=\"109\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/cronjob_m.png 448w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/cronjob_m-300x73.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n<p>En la siguiente ventana creamos nuestra tarea programada definiendo el tiempo para ejecutar un comando en linux que permitir\u00e1 generar el respaldo mysql y guardarlo en nuestra carpeta \u00abbackup_bd\u00bb<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1683\" src=\"http:\/\/creativapixel.com\/wp-content\/uploads\/2018\/07\/cron_m.png\" alt=\"\" width=\"448\" height=\"372\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/cron_m.png 448w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/cron_m-300x249.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n<p>En la imagen creamos una tarea programada que se ejecutara todos los d\u00edas a las 6am. Esta tarea programada ejecutar\u00e1 un comando linux que comprimir\u00e1 la base de datos y la copiara a la carpeta \u00abbackup_bd\u00bb con fecha actual del servidor<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">mysqldump --opt -q -uUSUARIO -pCLAVE NOMBREBD | gzip &gt; \/home\/usuario\/public_html\/backup_bd\/$(date '+\\%Y\\%m\\%d')_db.sql.gz<\/pre>\n<p>Guardamos y al llegar las 6am se generara el backup en la carpeta mencionada.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1684\" src=\"http:\/\/creativapixel.com\/wp-content\/uploads\/2018\/07\/backup_m.png\" alt=\"\" width=\"448\" height=\"334\" srcset=\"https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/backup_m.png 448w, https:\/\/creativapixel.com\/blog\/wp-content\/uploads\/2018\/07\/backup_m-300x224.png 300w\" sizes=\"auto, (max-width: 448px) 100vw, 448px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>En este art\u00edculo aprenderemos a crear un backup a nuestra base de datos mysql y almacenarlo en una carpeta en nuestra cuenta de hosting haciendo uso de una tarea programada &#8230;<\/p>\n","protected":false},"author":1,"featured_media":1686,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[39,38,18],"tags":[],"class_list":["post-1680","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cpanel","category-mysql","category-servidores-gnulinux"],"_links":{"self":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1680","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=1680"}],"version-history":[{"count":2,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1680\/revisions"}],"predecessor-version":[{"id":1695,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/posts\/1680\/revisions\/1695"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media\/1686"}],"wp:attachment":[{"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/media?parent=1680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/categories?post=1680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/creativapixel.com\/blog\/wp-json\/wp\/v2\/tags?post=1680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}