{"id":176,"date":"2018-07-08T10:00:04","date_gmt":"2018-07-08T10:00:04","guid":{"rendered":"https:\/\/quierohosting.com\/ayuda\/?p=176"},"modified":"2018-07-04T18:52:33","modified_gmt":"2018-07-04T18:52:33","slug":"exportar-base-de-datos-mysql","status":"publish","type":"post","link":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/","title":{"rendered":"Exportar base de datos MySQL"},"content":{"rendered":"<p>Puede exportar la base de datos completa o tablas especificas.<\/p>\n<p>Normalmente se exporta una base de datos completa para as\u00ed obtener un respaldo completo de su base de datos, pero puede tambi\u00e9n si lo desea realizar un respaldo de ciertas tablas.<\/p>\n<h2>Exportar y respaldar la base de datos completa<\/h2>\n<p>1. Acceda a su base de datos a trav\u00e9s de phpMyAdmin, puede ver c\u00f3mo acceder siguiendo la gu\u00eda\u00a0\u00ab<a href=\"https:\/\/quierohosting.com\/ayuda\/ingresar-a-phpmyadmin\">Ingresar a phpMyAdmin<\/a>\u00ab.<\/p>\n<p>2. En el men\u00fa izquierdo seleccione la base de datos que desea exportar.<\/p>\n<p>3. En el men\u00fa superior pulse el bot\u00f3n \u00abExportar\u00bb.<\/p>\n<p>4. Pulse el bot\u00f3n \u00abContinuar\u00bb. Complete la descarga del archivo .SQL.<\/p>\n<h2>Exportar y respaldar tablas espec\u00edficas de la base de datos<\/h2>\n<p>1. Acceda a su base de datos a trav\u00e9s de phpMyAdmin, puede ver c\u00f3mo acceder siguiendo la gu\u00eda\u00a0\u00ab<a href=\"https:\/\/quierohosting.com\/ayuda\/ingresar-a-phpmyadmin\">Ingresar a phpMyAdmin<\/a>\u00ab.<\/p>\n<p>2. En el men\u00fa izquierdo seleccione la tabla de base de datos que desea exportar.<\/p>\n<p>3. En el men\u00fa superior pulse el bot\u00f3n \u00abExportar\u00bb.<\/p>\n<p>4. En el \u00abM\u00e9todo de exportaci\u00f3n\u00bb seleccione \u00abPersonalizado\u00bb, se desplegar\u00e1n varias opciones de configuraci\u00f3n, entre ella las tablas que se exportaran, seleccione la o las que desea exportar.<\/p>\n<p>5. Pulse el bot\u00f3n \u00abContinuar\u00bb. Complete la descarga del archivo .SQL.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7],"tags":[],"class_list":["post-176","post","type-post","status-publish","format-standard","hentry","category-base-de-datos","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-50"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>C\u00f3mo exportar una base de datos MySQL - Ayuda Hosting<\/title>\n<meta name=\"description\" content=\"Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00f3mo exportar una base de datos MySQL - Ayuda Hosting\" \/>\n<meta property=\"og:description\" content=\"Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ayuda Hosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/quierohosting\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-08T10:00:04+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-07-04T18:52:33+00:00\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minuto\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\"},\"author\":{\"name\":\"admin\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#\/schema\/person\/4955f151c6a8c79250968f632541f512\"},\"headline\":\"Exportar base de datos MySQL\",\"datePublished\":\"2018-07-08T10:00:04+00:00\",\"dateModified\":\"2018-07-04T18:52:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\"},\"wordCount\":210,\"publisher\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#organization\"},\"articleSection\":[\"Base de Datos\"],\"inLanguage\":\"es\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\",\"url\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\",\"name\":\"C\u00f3mo exportar una base de datos MySQL - Ayuda Hosting\",\"isPartOf\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#website\"},\"datePublished\":\"2018-07-08T10:00:04+00:00\",\"dateModified\":\"2018-07-04T18:52:33+00:00\",\"description\":\"Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ayuda\",\"item\":\"https:\/\/quierohosting.com\/ayuda\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Base de Datos\",\"item\":\"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Exportar base de datos MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#website\",\"url\":\"https:\/\/quierohosting.com\/ayuda\/\",\"name\":\"Ayuda Hosting\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/quierohosting.com\/ayuda\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#organization\",\"name\":\"Quiero Hosting\",\"url\":\"https:\/\/quierohosting.com\/ayuda\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/quierohosting.com\/ayuda\/wp-content\/uploads\/2018\/06\/logo.svg\",\"contentUrl\":\"https:\/\/quierohosting.com\/ayuda\/wp-content\/uploads\/2018\/06\/logo.svg\",\"caption\":\"Quiero Hosting\"},\"image\":{\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/facebook.com\/quierohosting\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#\/schema\/person\/4955f151c6a8c79250968f632541f512\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/quierohosting.com\/ayuda\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/84f4a1fe049a4e7ec28432eaf8805d92?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/84f4a1fe049a4e7ec28432eaf8805d92?s=96&d=mm&r=g\",\"caption\":\"admin\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00f3mo exportar una base de datos MySQL - Ayuda Hosting","description":"Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/","og_locale":"es_ES","og_type":"article","og_title":"C\u00f3mo exportar una base de datos MySQL - Ayuda Hosting","og_description":"Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.","og_url":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/","og_site_name":"Ayuda Hosting","article_publisher":"https:\/\/facebook.com\/quierohosting","article_published_time":"2018-07-08T10:00:04+00:00","article_modified_time":"2018-07-04T18:52:33+00:00","author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"admin","Tiempo de lectura":"1 minuto"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/#article","isPartOf":{"@id":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/"},"author":{"name":"admin","@id":"https:\/\/quierohosting.com\/ayuda\/#\/schema\/person\/4955f151c6a8c79250968f632541f512"},"headline":"Exportar base de datos MySQL","datePublished":"2018-07-08T10:00:04+00:00","dateModified":"2018-07-04T18:52:33+00:00","mainEntityOfPage":{"@id":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/"},"wordCount":210,"publisher":{"@id":"https:\/\/quierohosting.com\/ayuda\/#organization"},"articleSection":["Base de Datos"],"inLanguage":"es"},{"@type":"WebPage","@id":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/","url":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/","name":"C\u00f3mo exportar una base de datos MySQL - Ayuda Hosting","isPartOf":{"@id":"https:\/\/quierohosting.com\/ayuda\/#website"},"datePublished":"2018-07-08T10:00:04+00:00","dateModified":"2018-07-04T18:52:33+00:00","description":"Aprende c\u00f3mo exportar y respaldar una base de datos completa o selecciona tablas especififas de una base de datos en MySQL a traves de phpMyAdmin.","breadcrumb":{"@id":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/exportar-base-de-datos-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ayuda","item":"https:\/\/quierohosting.com\/ayuda\/"},{"@type":"ListItem","position":2,"name":"Base de Datos","item":"https:\/\/quierohosting.com\/ayuda\/base-de-datos\/"},{"@type":"ListItem","position":3,"name":"Exportar base de datos MySQL"}]},{"@type":"WebSite","@id":"https:\/\/quierohosting.com\/ayuda\/#website","url":"https:\/\/quierohosting.com\/ayuda\/","name":"Ayuda Hosting","description":"","publisher":{"@id":"https:\/\/quierohosting.com\/ayuda\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quierohosting.com\/ayuda\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/quierohosting.com\/ayuda\/#organization","name":"Quiero Hosting","url":"https:\/\/quierohosting.com\/ayuda\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/quierohosting.com\/ayuda\/#\/schema\/logo\/image\/","url":"https:\/\/quierohosting.com\/ayuda\/wp-content\/uploads\/2018\/06\/logo.svg","contentUrl":"https:\/\/quierohosting.com\/ayuda\/wp-content\/uploads\/2018\/06\/logo.svg","caption":"Quiero Hosting"},"image":{"@id":"https:\/\/quierohosting.com\/ayuda\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/facebook.com\/quierohosting"]},{"@type":"Person","@id":"https:\/\/quierohosting.com\/ayuda\/#\/schema\/person\/4955f151c6a8c79250968f632541f512","name":"admin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/quierohosting.com\/ayuda\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/84f4a1fe049a4e7ec28432eaf8805d92?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/84f4a1fe049a4e7ec28432eaf8805d92?s=96&d=mm&r=g","caption":"admin"}}]}},"_links":{"self":[{"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/posts\/176"}],"collection":[{"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/comments?post=176"}],"version-history":[{"count":3,"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/posts\/176\/revisions"}],"predecessor-version":[{"id":268,"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/posts\/176\/revisions\/268"}],"wp:attachment":[{"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/media?parent=176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/categories?post=176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quierohosting.com\/ayuda\/wp-json\/wp\/v2\/tags?post=176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}