{"id":31851,"date":"2014-08-04T12:41:10","date_gmt":"2014-08-04T17:41:10","guid":{"rendered":"http:\/\/webirix.com\/?p=31851"},"modified":"2014-08-04T12:41:10","modified_gmt":"2014-08-04T17:41:10","slug":"respaldar-bases-de-datos-mysql-en-linux","status":"publish","type":"post","link":"https:\/\/webirix.com\/en\/respaldar-bases-de-datos-mysql-en-linux\/","title":{"rendered":"Backup Mysql Databases on Linux"},"content":{"rendered":"<p style=\"color: #333333;\"><a href=\"http:\/\/webirix.com\/wp-content\/uploads\/2014\/08\/loll.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-31853 aligncenter\" src=\"http:\/\/webirix.com\/wp-content\/uploads\/2014\/08\/loll.png\" alt=\"loll\" width=\"635\" height=\"247\" srcset=\"https:\/\/webirix.com\/wp-content\/uploads\/2014\/08\/loll.png 635w, https:\/\/webirix.com\/wp-content\/uploads\/2014\/08\/loll-300x116.png 300w\" sizes=\"auto, (max-width: 635px) 100vw, 635px\" \/><\/a><\/p>\n<p style=\"color: #333333;\">Bueno aqui esta un ejemplo practico de como respaldar todas sus bases de datos de forma rapido<\/p>\n<h3 style=\"color: #1c1c1c;\">Explicacion de comando<\/h3>\n<p>&nbsp;<\/p>\n<ul style=\"color: #000000;\">\n<li>&#8220;USUARIO&#8221; == Usuario dado de alta en mysql puede ser root o aquel que tenga permisos<\/li>\n<li>&#8220;CONTRASE\u00d1A&#8221; == Contrase\u00f1a del usuario<\/li>\n<li>&#8220;&#8211;all-databases&#8221; == Le indicamos las bases de datos a respaldar (con esto respalda todas)<\/li>\n<li>&#8220;192.168.1.202&#8221; == En mi caso la ip de el servidor a respaldar<\/li>\n<li>&#8220;\/var\/RESPALDO_MYSQL\/mysql-$(date +\\%d-\\%m-\\%Y).sql&#8221; == La ruta destino a donde se guardara respaldo<\/li>\n<\/ul>\n<p><br style=\"color: #000000;\" \/><strong style=\"color: #000000;\">Abrimos la consola<\/strong><span style=\"color: #000000;\">\u00a0<\/span><br style=\"color: #000000;\" \/><br style=\"color: #000000;\" \/><\/p>\n<h3 style=\"color: #1c1c1c;\">Codigo practico<\/h3>\n<p>&nbsp;<\/p>\n<pre style=\"color: #333333;\">[mysql@unidadlocal ~]# mysqldump -uUSUARIO -pCONTRASE\u00d1A --all-databases  -h 192.168.1.202   &gt; \/var\/RESPALDO_MYSQL\/mysql-$(date +\\%d-\\%m-\\%Y).sql<\/pre>\n<p>&nbsp;<\/p>\n<h3 style=\"color: #1c1c1c;\">Ejemplo con una sola base de datos<\/h3>\n<p>&nbsp;<\/p>\n<pre style=\"color: #333333;\">[mysql@unidadlocal ~]#mysqldump -uUSUARIO -pCONTRASE\u00d1A -h  192.168.1.202  --databases NOMBRE_DE_LA_BASE_DE_DATOS &gt; \/var\/RESPALDO_MYSQL\/mysql-$(date +\\%d-\\%m-\\%Y).sql\r\n\r\nFuente:\r\nhttp:\/\/unidadlocal.com\/<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Bueno aqui esta un ejemplo practico de como respaldar todas sus bases de datos de forma rapido Explicacion de comando &nbsp; &#8220;USUARIO&#8221; == Usuario dado de alta en mysql puede ser root o aquel que tenga permisos &#8220;CONTRASE\u00d1A&#8221; == Contrase\u00f1a del usuario &#8220;&#8211;all-databases&#8221; == Le indicamos las bases de datos a respaldar (con esto respalda &#8230;<\/p>","protected":false},"author":20,"featured_media":31852,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2024],"tags":[],"class_list":["post-31851","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-linux"],"jetpack_featured_media_url":"https:\/\/webirix.com\/wp-content\/uploads\/2014\/08\/linuxx.jpg","_links":{"self":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/31851","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/users\/20"}],"replies":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/comments?post=31851"}],"version-history":[{"count":1,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/31851\/revisions"}],"predecessor-version":[{"id":31854,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/posts\/31851\/revisions\/31854"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media\/31852"}],"wp:attachment":[{"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/media?parent=31851"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/categories?post=31851"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webirix.com\/en\/wp-json\/wp\/v2\/tags?post=31851"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}