{"id":6900,"date":"2018-05-29T13:19:35","date_gmt":"2018-05-29T11:19:35","guid":{"rendered":"https:\/\/blog.unelink.es\/?p=6900"},"modified":"2019-10-25T14:10:10","modified_gmt":"2019-10-25T12:10:10","slug":"exportar-una-copia-de-una-base-de-datos-usando-phpmyadmin-desde-cpanel","status":"publish","type":"post","link":"https:\/\/hosting.airetech.es\/blog\/wiki\/exportar-una-copia-de-una-base-de-datos-usando-phpmyadmin-desde-cpanel\/","title":{"rendered":"Exportar una copia de una base de datos usando phpMyAdmin desde cPanel"},"content":{"rendered":"<p>Si tienes un servidor (<a href=\"https:\/\/www.unelink.es\/servidores-dedicados-32.html\" target=\"_blank\" rel=\"noopener noreferrer\">dedicado<\/a> o <a href=\"https:\/\/www.unelink.es\/servidores-virtuales-33.html\" target=\"_blank\" rel=\"noopener noreferrer\">VPS<\/a>) o un <a href=\"https:\/\/www.unelink.es\/hosting-3.html\" target=\"_blank\" rel=\"noopener noreferrer\">hosting<\/a> con el panel de control cPanel, puedes <strong>exportar cualquier base de datos muy f\u00e1cilmente utilizando la herramienta phpMyAdmin<\/strong>.<\/p>\n<p>Lo primero que tienes que hacer es <strong>acceder a la cuenta del dominio que contiene la base de datos que quieres exportar<\/strong>.<\/p>\n<div id=\"attachment_6901\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-cpanel.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6901\" class=\"size-full wp-image-6901\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-cpanel.jpg\" alt=\"Acceso cPanel\" width=\"304\" height=\"347\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-cpanel.jpg 304w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-cpanel-263x300.jpg 263w\" sizes=\"auto, (max-width: 304px) 100vw, 304px\" \/><\/a><p id=\"caption-attachment-6901\" class=\"wp-caption-text\">Acceso cPanel<\/p><\/div>\n<p>Una vez dentro del panel, haz <strong>clic en el enlace phpMyAdmin<\/strong> dentro de la secci\u00f3n \"Bases de datos\".<\/p>\n<div id=\"attachment_6902\" style=\"width: 659px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-phpmyadmin.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6902\" class=\" wp-image-6902\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-phpmyadmin.jpg\" alt=\"Acceso phpMyAdmin\" width=\"649\" height=\"150\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-phpmyadmin.jpg 814w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-phpmyadmin-300x69.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-phpmyadmin-768x177.jpg 768w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/acceso-phpmyadmin-600x139.jpg 600w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/a><p id=\"caption-attachment-6902\" class=\"wp-caption-text\">Acceso phpMyAdmin<\/p><\/div>\n<p>En la pantalla principal de phpMyAdmin, en el listado de bases de datos, haz <strong>clic en el nombre de la base de datos<\/strong> que quieres exportar.<\/p>\n<div id=\"attachment_6903\" style=\"width: 427px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/listado-bases-datos.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6903\" class=\"size-full wp-image-6903\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/listado-bases-datos.jpg\" alt=\"Listado bases de datos\" width=\"417\" height=\"255\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/listado-bases-datos.jpg 417w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/listado-bases-datos-300x183.jpg 300w\" sizes=\"auto, (max-width: 417px) 100vw, 417px\" \/><\/a><p id=\"caption-attachment-6903\" class=\"wp-caption-text\">Listado bases de datos<\/p><\/div>\n<p>En el panel de herramientas de la base de datos, <strong>pulsa en el bot\u00f3n \"Exportar\"<\/strong>.<\/p>\n<div id=\"attachment_6904\" style=\"width: 659px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/herramientas-base-datos.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6904\" class=\" wp-image-6904\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/herramientas-base-datos.jpg\" alt=\"Herramientas de bases de datos\" width=\"649\" height=\"414\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/herramientas-base-datos.jpg 685w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/herramientas-base-datos-300x191.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/herramientas-base-datos-600x383.jpg 600w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/a><p id=\"caption-attachment-6904\" class=\"wp-caption-text\">Herramientas de bases de datos<\/p><\/div>\n<p>Por defecto, tienes la opci\u00f3n de exportar la base de datos completa como un archivo SQL. Sin embargo, puedes personalizar qu\u00e9 quieres exportar de la base de datos, as\u00ed como seleccionar otro formato de archivo. Para personalizar la exportaci\u00f3n, hac clic en la opci\u00f3n \"Personalizado\" de la secci\u00f3n \"M\u00e9todo de exportaci\u00f3n\".<\/p>\n<div id=\"attachment_6905\" style=\"width: 660px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/exportacion-personalizada.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6905\" class=\" wp-image-6905\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/exportacion-personalizada.jpg\" alt=\"Exportaci\u00f3n personalizada\" width=\"650\" height=\"628\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/exportacion-personalizada.jpg 747w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/exportacion-personalizada-300x290.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/exportacion-personalizada-600x580.jpg 600w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/a><p id=\"caption-attachment-6905\" class=\"wp-caption-text\">Exportaci\u00f3n personalizada<\/p><\/div>\n<p>Una vez hayas elegido el m\u00e9todo de exportaci\u00f3n y el formato del archivo de salida, <strong>pulsa el bot\u00f3n \"Continuar\".<\/strong><\/p>\n<div id=\"attachment_6906\" style=\"width: 661px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/continuar-exportacion.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6906\" class=\" wp-image-6906\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/continuar-exportacion.jpg\" alt=\"Continuar exportaci\u00f3n\" width=\"651\" height=\"415\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/continuar-exportacion.jpg 685w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/continuar-exportacion-300x191.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/continuar-exportacion-600x383.jpg 600w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/a><p id=\"caption-attachment-6906\" class=\"wp-caption-text\">Continuar exportaci\u00f3n<\/p><\/div>\n<p>Elige <strong>d\u00f3nde quieres guardar el archivo<\/strong> con la copia de la base de datos.<\/p>\n<div id=\"attachment_6908\" style=\"width: 659px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/guardar-exportacion.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-6908\" class=\" wp-image-6908\" src=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/guardar-exportacion.jpg\" alt=\"Guardar exportaci\u00f3n\" width=\"649\" height=\"428\" srcset=\"https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/guardar-exportacion.jpg 751w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/guardar-exportacion-300x198.jpg 300w, https:\/\/hosting.airetech.es\/blog\/wp-content\/uploads\/2018\/05\/guardar-exportacion-600x395.jpg 600w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/a><p id=\"caption-attachment-6908\" class=\"wp-caption-text\">Guardar exportaci\u00f3n<\/p><\/div>\n<p>Y con estos pasos ya tienes una copia de tu base de datos.<\/p>\n","protected":false},"excerpt":{"rendered":"Si tienes un servidor (dedicado o VPS) o un hosting con el panel de control cPanel, puedes exportar cualquier base de datos muy f\u00e1cilmente utilizando la herramienta phpMyAdmin. Lo primero que tienes que hacer es acceder a la cuenta del dominio que contiene la base de datos que quieres exportar. Una vez dentro del panel, haz clic en el enlace&nbsp;<a href=\"https:\/\/hosting.airetech.es\/blog\/wiki\/exportar-una-copia-de-una-base-de-datos-usando-phpmyadmin-desde-cpanel\/\" class=\"read-more\">Seguir leyendo<\/a>","protected":false},"author":1,"featured_media":6906,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[457,12,121,118,6],"tags":[224,20,107],"class_list":["post-6900","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bases-de-datos-panel-cpanel","category-bases-de-datos","category-panel-cpanel","category-mysql-2","category-wiki","tag-bases-de-datos","tag-mysql","tag-phpmyadmin","cat-457-id","cat-12-id","cat-121-id","cat-118-id","cat-6-id"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/6900","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/comments?post=6900"}],"version-history":[{"count":3,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/6900\/revisions"}],"predecessor-version":[{"id":8858,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/posts\/6900\/revisions\/8858"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media\/6906"}],"wp:attachment":[{"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/media?parent=6900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/categories?post=6900"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hosting.airetech.es\/blog\/wp-json\/wp\/v2\/tags?post=6900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}