{"id":10785,"date":"2018-05-29T17:45:35","date_gmt":"2018-05-29T21:45:35","guid":{"rendered":"https:\/\/adclichosting.com\/?p=10785"},"modified":"2021-06-11T12:00:19","modified_gmt":"2021-06-11T16:00:19","slug":"crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel","status":"publish","type":"post","link":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/","title":{"rendered":"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin"},"content":{"rendered":"\n<div class=\"schema-how-to wp-block-yoast-how-to-block\"><p class=\"schema-how-to-description\">Aprender\u00a0 a manejar Phpmyadmin Cpanel es importante ya que las bases de datos es una pieza importante en la construcci\u00f3n de nuestro sitio web. Independientemente del Sistema Manejador de Contenidos (CMS) que vayamos a utilizar. Todos los CMS, en especial los mas comunes, sea WordPress, Joomla, PrestaShop, Moodle, etc, manejan Bases de Datos.<br\/>Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispongamos de los datos adecuados para conectarla con la aplicaci\u00f3n o CMS que vayamos a utilizar.<br\/>Esta gu\u00eda fue creada con el fin de disminuir el nivel de errores presentados al momento de crear nuestra base de datos. Independientemente de si seamos usuario avanzado o estemos empezando en el mundo del hosting y la construcci\u00f3n de nuestro sitio web.<br\/><br\/>Veamos como crear una Base de Datos:<\/p> <ol class=\"schema-how-to-steps\"><li class=\"schema-how-to-step\" id=\"how-to-step-1623426083763\"><strong class=\"schema-how-to-step-name\">Ingresar a cPanel.<\/strong> <p class=\"schema-how-to-step-text\">Una vez dentro de su cPanel, haga clic en el icono de \u201cMySQL\u00ae Databases\u201d, dentro de las opciones de Base de Datos.<br\/>Una vez dentro del apartado, en la parte superior del mismo, podr\u00e1 agregar el nombre de usuario que desea para la Base de Datos y hacer clic en \u201cCrear una base de datos\u201d.<img loading=\"lazy\" decoding=\"async\" width=\"722\" height=\"205\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/1-9.jpg\" class=\"attachment-full size-full\" alt=\"\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/1-9.jpg 722w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/1-9-300x85.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/1-9-720x205.jpg 720w\" sizes=\"auto, (max-width: 722px) 100vw, 722px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426258120\"><strong class=\"schema-how-to-step-name\">Crear usuario.<\/strong> <p class=\"schema-how-to-step-text\">Ahora s\u00f3lo nos queda crear un usuario para poder conectarnos a la Base de Datos. Para esto nos vamos a la misma secci\u00f3n de \u201cMySQL\u00ae Databases\u201d, en la parte inferior al apartado de la creaci\u00f3n de bases de datos, encontraremos \u00abUsuarios MySQL\u00bb<br\/><br\/>Desde aqu\u00ed debe ingresar el nombre de usuario que desee, la contrase\u00f1a y clic en \u00abCrear Usuario\u00bb.<img loading=\"lazy\" decoding=\"async\" width=\"926\" height=\"469\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/2-11.jpg\" class=\"attachment-full size-full\" alt=\"\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/2-11.jpg 926w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/2-11-300x152.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/2-11-768x389.jpg 768w\" sizes=\"auto, (max-width: 926px) 100vw, 926px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426331300\"><strong class=\"schema-how-to-step-name\">A\u00f1adir usuario a la base de dato.<\/strong> <p class=\"schema-how-to-step-text\">Una vez creado el mismo, debe agregarlo a la base de datos, dentro del mismo apartado, tal cual se ve en la imagen.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"681\" height=\"272\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/3-5.jpg\" class=\"attachment-full size-full\" alt=\"\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/3-5.jpg 681w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/3-5-300x120.jpg 300w\" sizes=\"auto, (max-width: 681px) 100vw, 681px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426424553\"><strong class=\"schema-how-to-step-name\">Administrar privilegios<\/strong> <p class=\"schema-how-to-step-text\">Al pulsar el bot\u00f3n \u201cA\u00f1adir\u201d, podremos seleccionar los permisos que le daremos al usuario sobre la Base de Datos.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"717\" height=\"486\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/4-9.jpg\" class=\"attachment-full size-full\" alt=\"\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/4-9.jpg 717w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/4-9-300x203.jpg 300w\" sizes=\"auto, (max-width: 717px) 100vw, 717px\" \/><br\/><br\/>Una vez hecho los pasos anteriores podremos conectarnos a nuestra base de datos sin problemas.<\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426539962\"><strong class=\"schema-how-to-step-name\">Restaurar Base de Datos:<\/strong> <p class=\"schema-how-to-step-text\">Si por el contrario deseamos importar una base de datos desde nuestro cPanel y de una manera sencilla. Realizaremos lo siguiente:<br\/>Ingresar a nuestro cPanel y hacer clic en \u00abCopias de seguridad\u00bb de la secci\u00f3n de \u00abArchivos\u00bb.<br\/>Una vez hayamos ingresado buscaremos la opci\u00f3n \u00abRestaurar una copia de seguridad de la base de datos MySQL\u00bb.<br\/><img loading=\"lazy\" decoding=\"async\" width=\"633\" height=\"162\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/5-5.jpg\" class=\"attachment-full size-full\" alt=\"\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/5-5.jpg 633w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/5-5-300x77.jpg 300w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426594222\"><strong class=\"schema-how-to-step-name\">Exportar una Base de Datos.<\/strong> <p class=\"schema-how-to-step-text\">Para realizar una copia\/respaldo de nuestra base de datos creada, iremos a la secci\u00f3n de \u00ab<a href=\"https:\/\/es.wikipedia.org\/wiki\/PhpMyAdmin\">phpMyAdmin<\/a>\u00bb de nuestro cPanel.<br\/>Esto nos enviar\u00e1 al Gestor phpMyAdmin donde seleccionaremos la BD que queremos respaldar. Clic a la opci\u00f3n exportar, ubicada en el men\u00fa derecho en la parte superior, tal como se muestra a continuaci\u00f3n.<img loading=\"lazy\" decoding=\"async\" width=\"1222\" height=\"408\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/6-3.jpg\" class=\"attachment-full size-full\" alt=\"\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/6-3.jpg 1222w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/6-3-300x100.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/6-3-768x256.jpg 768w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/6-3-1024x342.jpg 1024w\" sizes=\"auto, (max-width: 1222px) 100vw, 1222px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426776394\"><strong class=\"schema-how-to-step-name\">Importar DB pt:1<\/strong> <p class=\"schema-how-to-step-text\">Primero accede al phpMyAdmin, es recomendable crear una nueva base de datos para proceder a importar nuestra data.<img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"391\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import.jpg\" class=\"attachment-full size-full\" alt=\"phpmyadmin-import\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import.jpg 830w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import-300x141.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import-768x362.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426782091\"><strong class=\"schema-how-to-step-name\">Importar DB pt:2<\/strong> <p class=\"schema-how-to-step-text\">Una vez has seleccionado \u00abImportar\u00bb necesitas el archivo con los tu base de datos, se mostra\u00e1 una ventana donde te permite examinar y buscar en tu disco duro el archivo de la base de datos.<br\/>Clic a en Seleccionar archivo, selecciona el archivo y acepta,\u00a0es recomendable tener la copia de la base de datos en un archivo con extensi\u00f3n .sql, .zip, .tar.gz o .tgz en el disco duro de tu ordenador.<img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"393\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import15.jpg\" class=\"attachment-full size-full\" alt=\"phpmyadmin-import\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import15.jpg 830w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import15-300x142.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import15-768x364.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426933638\"><strong class=\"schema-how-to-step-name\">Importar DB pt:3<\/strong> <p class=\"schema-how-to-step-text\">Si la base de datos a importar pesa m\u00e1s de 30 MB tienes que realizar la importaci\u00f3n a trav\u00e9s del Panel de control de cdmon. Si la base de datos pesa menos de 30 MB puedes realizarlo desde el mismo PhpMyAdmin.<img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"395\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import2.jpg\" class=\"attachment-full size-full\" alt=\"phpmyadmin-import\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import2.jpg 830w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import2-300x143.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import2-768x365.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623426988767\"><strong class=\"schema-how-to-step-name\">Importar DB pt:4<\/strong> <p class=\"schema-how-to-step-text\">Finalmente queda hacer clic en Continuar y esperar a que se cargue el archivo, se puede demorar dependiendo del tama\u00f1o del fichero.<br\/>En la selecci\u00f3n de \u00abConjunto de caracteres del archivo\u00bb tienes que seleccionar la misma opci\u00f3n que escogiste cuando exportaste la base de datos, pues usualmente\u00a0se utiliza UTF-8.<img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"395\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import3.jpg\" class=\"attachment-full size-full\" alt=\"phpmyadmin-import\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import3.jpg 830w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import3-300x143.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import3-768x365.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/p> <\/li><li class=\"schema-how-to-step\" id=\"how-to-step-1623427040192\"><strong class=\"schema-how-to-step-name\">Importar DB pt:4<\/strong> <p class=\"schema-how-to-step-text\">Se mostrar\u00e1 un mensaje de confirmaci\u00f3n en su pantalla. Deber\u00eda poder ver las tablas en la columna a la izquierda en phpMyAdmin.<img loading=\"lazy\" decoding=\"async\" width=\"830\" height=\"310\" src=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import4.jpg\" class=\"attachment-full size-full\" alt=\"phpmyadmin-import\" style=\"max-width: 100%; height: auto;\" srcset=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import4.jpg 830w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import4-300x112.jpg 300w, https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2020\/01\/phpmyadmin-import4-768x287.jpg 768w\" sizes=\"auto, (max-width: 830px) 100vw, 830px\" \/><\/p> <\/li><\/ol><\/div>\n\n\n\n\n\n<p class=\"yoast-reading-time__wrapper\"><span class=\"yoast-reading-time__icon\"><svg aria-hidden=\"true\" focusable=\"false\" data-icon=\"clock\" width=\"20\" height=\"20\" fill=\"none\" stroke=\"currentColor\" style=\"display:inline-block;vertical-align:-0.1em\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewbox=\"0 0 24 24\"><path stroke-linecap=\"round\" stroke-linejoin=\"round\" stroke-width=\"2\" d=\"M12 8v4l3 3m6-3a9 9 0 11-18 0 9 9 0 0118 0z\"><\/path><\/svg><\/span><span class=\"yoast-reading-time__spacer\" style=\"display:inline-block;width:1em\"><\/span><span class=\"yoast-reading-time__descriptive-text\">Tiempo de lectura estimado:  <\/span><span class=\"yoast-reading-time__reading-time\">6<\/span><span class=\"yoast-reading-time__time-unit\"> minutos<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":2,"featured_media":10796,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3310],"tags":[],"class_list":["post-10785","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrar-bases-de-datos-cpanel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.0 (Yoast SEO v28.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Phpmyadmin Cpanel - Administrar Bases de Datos en phpMyAdmin - Adclic Hosting<\/title>\n<meta name=\"description\" content=\"Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispon\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Phpmyadmin Cpanel - Administrar Bases de Datos en phpMyAdmin\" \/>\n<meta property=\"og:description\" content=\"Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispon\" \/>\n<meta property=\"og:url\" content=\"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Adclic Hosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/josuejosefuentes\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-29T21:45:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-06-11T16:00:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/Base-de-datos.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"700\" \/>\n\t<meta property=\"og:image:height\" content=\"500\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Fuentes\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@josuejosefuente\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fuentes\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/\"},\"author\":{\"name\":\"Fuentes\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/15a62c1faa6e29f6d1a618ba5de17aa0\"},\"headline\":\"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin\",\"datePublished\":\"2018-05-29T21:45:35+00:00\",\"dateModified\":\"2021-06-11T16:00:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/\"},\"wordCount\":703,\"commentCount\":1,\"image\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Base-de-datos.jpg\",\"articleSection\":[\"Administrar Bases de Datos cPanel\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/\",\"name\":\"Phpmyadmin Cpanel - Administrar Bases de Datos en phpMyAdmin - Adclic Hosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Base-de-datos.jpg\",\"datePublished\":\"2018-05-29T21:45:35+00:00\",\"dateModified\":\"2021-06-11T16:00:19+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/15a62c1faa6e29f6d1a618ba5de17aa0\"},\"description\":\"Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispon\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Base-de-datos.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/Base-de-datos.jpg\",\"width\":700,\"height\":500},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/\",\"name\":\"Adclic Hosting\",\"description\":\"Hosting Empresarial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/15a62c1faa6e29f6d1a618ba5de17aa0\",\"name\":\"Fuentes\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78da906689e832bdc83574aef38a9ab21a9161cfa19d97fb6695fdcfe220fc9d?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78da906689e832bdc83574aef38a9ab21a9161cfa19d97fb6695fdcfe220fc9d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/78da906689e832bdc83574aef38a9ab21a9161cfa19d97fb6695fdcfe220fc9d?s=96&d=mm&r=g\",\"caption\":\"Fuentes\"},\"sameAs\":[\"https:\\\/\\\/www.adclichosting.com\",\"https:\\\/\\\/www.facebook.com\\\/josuejosefuentes\",\"https:\\\/\\\/x.com\\\/josuejosefuente\"],\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/author\\\/paadclic\\\/\"},{\"@type\":\"HowTo\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#howto-1\",\"name\":\"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#article\"},\"description\":\"Aprender\u00a0 a manejar Phpmyadmin Cpanel es importante ya que las bases de datos es una pieza importante en la construcci\u00f3n de nuestro sitio web. Independientemente del Sistema Manejador de Contenidos (CMS) que vayamos a utilizar. Todos los CMS, en especial los mas comunes, sea WordPress, Joomla, PrestaShop, Moodle, etc, manejan Bases de Datos.<br\\\/>Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispongamos de los datos adecuados para conectarla con la aplicaci\u00f3n o CMS que vayamos a utilizar.<br\\\/>Esta gu\u00eda fue creada con el fin de disminuir el nivel de errores presentados al momento de crear nuestra base de datos. Independientemente de si seamos usuario avanzado o estemos empezando en el mundo del hosting y la construcci\u00f3n de nuestro sitio web.<br\\\/><br\\\/>Veamos como crear una Base de Datos:\",\"step\":[{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426083763\",\"name\":\"Ingresar a cPanel.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Una vez dentro de su cPanel, haga clic en el icono de \u201cMySQL\u00ae Databases\u201d, dentro de las opciones de Base de Datos.Una vez dentro del apartado, en la parte superior del mismo, podr\u00e1 agregar el nombre de usuario que desea para la Base de Datos y hacer clic en \u201cCrear una base de datos\u201d.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-bb08e144772b8bf784218f5f554e6515\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/1-9.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/1-9.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426258120\",\"name\":\"Crear usuario.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Ahora s\u00f3lo nos queda crear un usuario para poder conectarnos a la Base de Datos. Para esto nos vamos a la misma secci\u00f3n de \u201cMySQL\u00ae Databases\u201d, en la parte inferior al apartado de la creaci\u00f3n de bases de datos, encontraremos \\\"Usuarios MySQL\\\"Desde aqu\u00ed debe ingresar el nombre de usuario que desee, la contrase\u00f1a y clic en \\\"Crear Usuario\\\".\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-3f242f0d31ed5b5c4280fae17a2b3aa6\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/2-11.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/2-11.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426331300\",\"name\":\"A\u00f1adir usuario a la base de dato.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Una vez creado el mismo, debe agregarlo a la base de datos, dentro del mismo apartado, tal cual se ve en la imagen.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-5130133f02130443f403e628ae87d266\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/3-5.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/3-5.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426424553\",\"name\":\"Administrar privilegios\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Al pulsar el bot\u00f3n \u201cA\u00f1adir\u201d, podremos seleccionar los permisos que le daremos al usuario sobre la Base de Datos.Una vez hecho los pasos anteriores podremos conectarnos a nuestra base de datos sin problemas.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-3f553de4c738cf2036f3e9f265a7a0ac\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/4-9.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/4-9.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426539962\",\"name\":\"Restaurar Base de Datos:\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Si por el contrario deseamos importar una base de datos desde nuestro cPanel y de una manera sencilla. Realizaremos lo siguiente:Ingresar a nuestro cPanel y hacer clic en \\\"Copias de seguridad\\\" de la secci\u00f3n de \\\"Archivos\\\".Una vez hayamos ingresado buscaremos la opci\u00f3n \\\"Restaurar una copia de seguridad de la base de datos MySQL\\\".\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-3fe97e567b8c41e665c46399edd17266\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/5-5.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/5-5.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426594222\",\"name\":\"Exportar una Base de Datos.\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Para realizar una copia\\\/respaldo de nuestra base de datos creada, iremos a la secci\u00f3n de \\\"phpMyAdmin\\\" de nuestro cPanel.Esto nos enviar\u00e1 al Gestor phpMyAdmin donde seleccionaremos la BD que queremos respaldar. Clic a la opci\u00f3n exportar, ubicada en el men\u00fa derecho en la parte superior, tal como se muestra a continuaci\u00f3n.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-e548f152069f5f2ae378a9ef2e680d9a\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/6-3.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2018\\\/05\\\/6-3.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426776394\",\"name\":\"Importar DB pt:1\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Primero accede al phpMyAdmin, es recomendable crear una nueva base de datos para proceder a importar nuestra data.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-2aa1eb4612c667a5b32759bf0be0afad\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426782091\",\"name\":\"Importar DB pt:2\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Una vez has seleccionado \\\"Importar\\\" necesitas el archivo con los tu base de datos, se mostra\u00e1 una ventana donde te permite examinar y buscar en tu disco duro el archivo de la base de datos.Clic a en Seleccionar archivo, selecciona el archivo y acepta,\u00a0es recomendable tener la copia de la base de datos en un archivo con extensi\u00f3n .sql, .zip, .tar.gz o .tgz en el disco duro de tu ordenador.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-793f42d92d68699cd8e85cabad629504\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import15.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import15.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426933638\",\"name\":\"Importar DB pt:3\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Si la base de datos a importar pesa m\u00e1s de 30 MB tienes que realizar la importaci\u00f3n a trav\u00e9s del Panel de control de cdmon. Si la base de datos pesa menos de 30 MB puedes realizarlo desde el mismo PhpMyAdmin.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-fe307be57660bf15289e7c0496cf87e3\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import2.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import2.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623426988767\",\"name\":\"Importar DB pt:4\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Finalmente queda hacer clic en Continuar y esperar a que se cargue el archivo, se puede demorar dependiendo del tama\u00f1o del fichero.En la selecci\u00f3n de \\\"Conjunto de caracteres del archivo\\\" tienes que seleccionar la misma opci\u00f3n que escogiste cuando exportaste la base de datos, pues usualmente\u00a0se utiliza UTF-8.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-6bd11982ea13242c9b4b10281150e957\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import3.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import3.jpg\"}},{\"@type\":\"HowToStep\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#how-to-step-1623427040192\",\"name\":\"Importar DB pt:4\",\"itemListElement\":[{\"@type\":\"HowToDirection\",\"text\":\"Se mostrar\u00e1 un mensaje de confirmaci\u00f3n en su pantalla. Deber\u00eda poder ver las tablas en la columna a la izquierda en phpMyAdmin.\"}],\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/adclichosting.com\\\/blog\\\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\\\/#schema-image-6ed4a5e63639a1e23098024ddd029f8f\",\"url\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import4.jpg\",\"contentUrl\":\"https:\\\/\\\/adclichosting.com\\\/wp-content\\\/uploads\\\/2020\\\/01\\\/phpmyadmin-import4.jpg\"}}],\"inLanguage\":\"es\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Phpmyadmin Cpanel - Administrar Bases de Datos en phpMyAdmin - Adclic Hosting","description":"Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispon","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:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/","og_locale":"es_ES","og_type":"article","og_title":"Phpmyadmin Cpanel - Administrar Bases de Datos en phpMyAdmin","og_description":"Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispon","og_url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/","og_site_name":"Adclic Hosting","article_author":"https:\/\/www.facebook.com\/josuejosefuentes","article_published_time":"2018-05-29T21:45:35+00:00","article_modified_time":"2021-06-11T16:00:19+00:00","og_image":[{"width":700,"height":500,"url":"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/Base-de-datos.jpg","type":"image\/jpeg"}],"author":"Fuentes","twitter_card":"summary_large_image","twitter_creator":"@josuejosefuente","twitter_misc":{"Escrito por":"Fuentes","Tiempo de lectura":"6 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#article","isPartOf":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/"},"author":{"name":"Fuentes","@id":"https:\/\/adclichosting.com\/blog\/#\/schema\/person\/15a62c1faa6e29f6d1a618ba5de17aa0"},"headline":"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin","datePublished":"2018-05-29T21:45:35+00:00","dateModified":"2021-06-11T16:00:19+00:00","mainEntityOfPage":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/"},"wordCount":703,"commentCount":1,"image":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/Base-de-datos.jpg","articleSection":["Administrar Bases de Datos cPanel"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/","name":"Phpmyadmin Cpanel - Administrar Bases de Datos en phpMyAdmin - Adclic Hosting","isPartOf":{"@id":"https:\/\/adclichosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/Base-de-datos.jpg","datePublished":"2018-05-29T21:45:35+00:00","dateModified":"2021-06-11T16:00:19+00:00","author":{"@id":"https:\/\/adclichosting.com\/blog\/#\/schema\/person\/15a62c1faa6e29f6d1a618ba5de17aa0"},"description":"Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispon","breadcrumb":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#primaryimage","url":"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/Base-de-datos.jpg","contentUrl":"https:\/\/adclichosting.com\/blog\/wp-content\/uploads\/2018\/05\/Base-de-datos.jpg","width":700,"height":500},{"@type":"BreadcrumbList","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/adclichosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/adclichosting.com\/blog\/#website","url":"https:\/\/adclichosting.com\/blog\/","name":"Adclic Hosting","description":"Hosting Empresarial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/adclichosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/adclichosting.com\/blog\/#\/schema\/person\/15a62c1faa6e29f6d1a618ba5de17aa0","name":"Fuentes","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/78da906689e832bdc83574aef38a9ab21a9161cfa19d97fb6695fdcfe220fc9d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/78da906689e832bdc83574aef38a9ab21a9161cfa19d97fb6695fdcfe220fc9d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/78da906689e832bdc83574aef38a9ab21a9161cfa19d97fb6695fdcfe220fc9d?s=96&d=mm&r=g","caption":"Fuentes"},"sameAs":["https:\/\/www.adclichosting.com","https:\/\/www.facebook.com\/josuejosefuentes","https:\/\/x.com\/josuejosefuente"],"url":"https:\/\/adclichosting.com\/blog\/author\/paadclic\/"},{"@type":"HowTo","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#howto-1","name":"Phpmyadmin Cpanel &#8211; Administrar Bases de Datos en phpMyAdmin","mainEntityOfPage":{"@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#article"},"description":"Aprender\u00a0 a manejar Phpmyadmin Cpanel es importante ya que las bases de datos es una pieza importante en la construcci\u00f3n de nuestro sitio web. Independientemente del Sistema Manejador de Contenidos (CMS) que vayamos a utilizar. Todos los CMS, en especial los mas comunes, sea WordPress, Joomla, PrestaShop, Moodle, etc, manejan Bases de Datos.<br\/>Realizar el proceso de crear la Base de datos phpmyadmin cpanel y que esta tenga \u00e9xito en su conexi\u00f3n depender\u00e1 en buena medida de que dispongamos de los datos adecuados para conectarla con la aplicaci\u00f3n o CMS que vayamos a utilizar.<br\/>Esta gu\u00eda fue creada con el fin de disminuir el nivel de errores presentados al momento de crear nuestra base de datos. Independientemente de si seamos usuario avanzado o estemos empezando en el mundo del hosting y la construcci\u00f3n de nuestro sitio web.<br\/><br\/>Veamos como crear una Base de Datos:","step":[{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426083763","name":"Ingresar a cPanel.","itemListElement":[{"@type":"HowToDirection","text":"Una vez dentro de su cPanel, haga clic en el icono de \u201cMySQL\u00ae Databases\u201d, dentro de las opciones de Base de Datos.Una vez dentro del apartado, en la parte superior del mismo, podr\u00e1 agregar el nombre de usuario que desea para la Base de Datos y hacer clic en \u201cCrear una base de datos\u201d."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-bb08e144772b8bf784218f5f554e6515","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/1-9.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/1-9.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426258120","name":"Crear usuario.","itemListElement":[{"@type":"HowToDirection","text":"Ahora s\u00f3lo nos queda crear un usuario para poder conectarnos a la Base de Datos. Para esto nos vamos a la misma secci\u00f3n de \u201cMySQL\u00ae Databases\u201d, en la parte inferior al apartado de la creaci\u00f3n de bases de datos, encontraremos \"Usuarios MySQL\"Desde aqu\u00ed debe ingresar el nombre de usuario que desee, la contrase\u00f1a y clic en \"Crear Usuario\"."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-3f242f0d31ed5b5c4280fae17a2b3aa6","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/2-11.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/2-11.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426331300","name":"A\u00f1adir usuario a la base de dato.","itemListElement":[{"@type":"HowToDirection","text":"Una vez creado el mismo, debe agregarlo a la base de datos, dentro del mismo apartado, tal cual se ve en la imagen."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-5130133f02130443f403e628ae87d266","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/3-5.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/3-5.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426424553","name":"Administrar privilegios","itemListElement":[{"@type":"HowToDirection","text":"Al pulsar el bot\u00f3n \u201cA\u00f1adir\u201d, podremos seleccionar los permisos que le daremos al usuario sobre la Base de Datos.Una vez hecho los pasos anteriores podremos conectarnos a nuestra base de datos sin problemas."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-3f553de4c738cf2036f3e9f265a7a0ac","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/4-9.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/4-9.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426539962","name":"Restaurar Base de Datos:","itemListElement":[{"@type":"HowToDirection","text":"Si por el contrario deseamos importar una base de datos desde nuestro cPanel y de una manera sencilla. Realizaremos lo siguiente:Ingresar a nuestro cPanel y hacer clic en \"Copias de seguridad\" de la secci\u00f3n de \"Archivos\".Una vez hayamos ingresado buscaremos la opci\u00f3n \"Restaurar una copia de seguridad de la base de datos MySQL\"."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-3fe97e567b8c41e665c46399edd17266","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/5-5.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/5-5.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426594222","name":"Exportar una Base de Datos.","itemListElement":[{"@type":"HowToDirection","text":"Para realizar una copia\/respaldo de nuestra base de datos creada, iremos a la secci\u00f3n de \"phpMyAdmin\" de nuestro cPanel.Esto nos enviar\u00e1 al Gestor phpMyAdmin donde seleccionaremos la BD que queremos respaldar. Clic a la opci\u00f3n exportar, ubicada en el men\u00fa derecho en la parte superior, tal como se muestra a continuaci\u00f3n."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-e548f152069f5f2ae378a9ef2e680d9a","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/6-3.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2018\/05\/6-3.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426776394","name":"Importar DB pt:1","itemListElement":[{"@type":"HowToDirection","text":"Primero accede al phpMyAdmin, es recomendable crear una nueva base de datos para proceder a importar nuestra data."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-2aa1eb4612c667a5b32759bf0be0afad","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426782091","name":"Importar DB pt:2","itemListElement":[{"@type":"HowToDirection","text":"Una vez has seleccionado \"Importar\" necesitas el archivo con los tu base de datos, se mostra\u00e1 una ventana donde te permite examinar y buscar en tu disco duro el archivo de la base de datos.Clic a en Seleccionar archivo, selecciona el archivo y acepta,\u00a0es recomendable tener la copia de la base de datos en un archivo con extensi\u00f3n .sql, .zip, .tar.gz o .tgz en el disco duro de tu ordenador."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-793f42d92d68699cd8e85cabad629504","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import15.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import15.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426933638","name":"Importar DB pt:3","itemListElement":[{"@type":"HowToDirection","text":"Si la base de datos a importar pesa m\u00e1s de 30 MB tienes que realizar la importaci\u00f3n a trav\u00e9s del Panel de control de cdmon. Si la base de datos pesa menos de 30 MB puedes realizarlo desde el mismo PhpMyAdmin."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-fe307be57660bf15289e7c0496cf87e3","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import2.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import2.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623426988767","name":"Importar DB pt:4","itemListElement":[{"@type":"HowToDirection","text":"Finalmente queda hacer clic en Continuar y esperar a que se cargue el archivo, se puede demorar dependiendo del tama\u00f1o del fichero.En la selecci\u00f3n de \"Conjunto de caracteres del archivo\" tienes que seleccionar la misma opci\u00f3n que escogiste cuando exportaste la base de datos, pues usualmente\u00a0se utiliza UTF-8."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-6bd11982ea13242c9b4b10281150e957","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import3.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import3.jpg"}},{"@type":"HowToStep","url":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#how-to-step-1623427040192","name":"Importar DB pt:4","itemListElement":[{"@type":"HowToDirection","text":"Se mostrar\u00e1 un mensaje de confirmaci\u00f3n en su pantalla. Deber\u00eda poder ver las tablas en la columna a la izquierda en phpMyAdmin."}],"image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/adclichosting.com\/blog\/crear-restaurar-importar-y-exportar-bases-de-datos-phpmyadmin-cpanel\/#schema-image-6ed4a5e63639a1e23098024ddd029f8f","url":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import4.jpg","contentUrl":"https:\/\/adclichosting.com\/wp-content\/uploads\/2020\/01\/phpmyadmin-import4.jpg"}}],"inLanguage":"es"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/posts\/10785","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/comments?post=10785"}],"version-history":[{"count":0,"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/posts\/10785\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/media\/10796"}],"wp:attachment":[{"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/media?parent=10785"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/categories?post=10785"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adclichosting.com\/blog\/wp-json\/wp\/v2\/tags?post=10785"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}