{"id":181,"date":"2021-07-25T13:38:52","date_gmt":"2021-07-25T13:38:52","guid":{"rendered":"https:\/\/www.reselhost.com.ar\/base\/?p=181"},"modified":"2021-07-25T13:38:52","modified_gmt":"2021-07-25T13:38:52","slug":"como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel","status":"publish","type":"post","link":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/","title":{"rendered":"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel"},"content":{"rendered":"\n<p><\/p>\n\n\n\n<p><strong>1.<\/strong>\u00a0Inicie sesi\u00f3n en su cuenta de cPanel.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>2.<\/strong>\u00a0In the \u00ab<strong>Databases<\/strong>\u00bb section, click on \u00ab<strong>phpMyAdmin<\/strong>\u00bb Icon.<\/p>\n\n\n\n<p><br><img decoding=\"async\" src=\"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif\" alt=\"\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>3.<\/strong>\u00a0In left side-bar, Click on the expand button to expand database like \u00abexample\u00bb.<\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><img decoding=\"async\" src=\"https:\/\/www.reselhost.com\/img\/phpmyadmin-expand-db.gif\" alt=\"\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>4.<\/strong>\u00a0Under your cPanel username, you can see list of all databases. Select appropriate database which you want to optimize.<\/p>\n\n\n\n<p><br><img decoding=\"async\" src=\"https:\/\/www.reselhost.com\/img\/phpmyadmin-db-list.gif\" alt=\"\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p><strong>5.\u00a0<\/strong>Scroll down and mark \u00ab<strong>Check All<\/strong>\u00bb then click on the Drop-down option and select \u00ab<strong>Optimize tables<\/strong>\u00ab.<\/p>\n\n\n\n<p><br><img decoding=\"async\" src=\"https:\/\/www.reselhost.com\/img\/optimize-db.gif\" alt=\"\"><\/p>\n\n\n\n<p><\/p>\n\n\n\n<p>Tabla optimizada con \u00e9xito.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>1.\u00a0Inicie sesi\u00f3n en su cuenta de cPanel. 2.\u00a0In the \u00abDatabases\u00bb section, click on \u00abphpMyAdmin\u00bb Icon. 3.\u00a0In left side-bar, Click on the expand button to expand database like \u00abexample\u00bb. 4.\u00a0Under your cPanel username, you can see list of all databases. Select appropriate database which you want to optimize. 5.\u00a0Scroll down and mark \u00abCheck All\u00bb then click [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[50,77],"class_list":["post-181","post","type-post","status-publish","format-standard","hentry","category-base-de-datos-mysql","tag-cpanel","tag-mysql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.1.1 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Optimizar Base de Datos MySQL por phpMyAdmin cPanel - Reselhost<\/title>\n<meta name=\"description\" content=\"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel Base de Conocimientos con Web Hosting y Reseller Hosting Gratuito.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Optimizar Base de Datos MySQL por phpMyAdmin cPanel - Reselhost\" \/>\n<meta property=\"og:description\" content=\"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel Base de Conocimientos con Web Hosting y Reseller Hosting Gratuito.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\" \/>\n<meta property=\"og:site_name\" content=\"Reselhost\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/reselhost\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-25T13:38:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.intelhost.com\/img\/phpmyadmin-icon.gif\" \/>\n<meta name=\"author\" content=\"soporte\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@reselhost\" \/>\n<meta name=\"twitter:site\" content=\"@reselhost\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"soporte\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\"},\"author\":{\"name\":\"soporte\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#\/schema\/person\/d9a5924efda55954d13bd172c785f862\"},\"headline\":\"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel\",\"datePublished\":\"2021-07-25T13:38:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\"},\"wordCount\":83,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif\",\"keywords\":[\"cPanel\",\"MySQL\"],\"articleSection\":[\"Base de Datos MySQL\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\",\"url\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\",\"name\":\"Optimizar Base de Datos MySQL por phpMyAdmin cPanel - Reselhost\",\"isPartOf\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif\",\"datePublished\":\"2021-07-25T13:38:52+00:00\",\"description\":\"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel Base de Conocimientos con Web Hosting y Reseller Hosting Gratuito.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage\",\"url\":\"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif\",\"contentUrl\":\"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.reselhost.mx\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#website\",\"url\":\"https:\/\/www.reselhost.mx\/kb\/\",\"name\":\"Reselhost\",\"description\":\"Base de Conocimientos Reseller Hosting\",\"publisher\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.reselhost.mx\/kb\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#organization\",\"name\":\"Reselhost LLC\",\"url\":\"https:\/\/www.reselhost.mx\/kb\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.reselhost.mx\/kb\/wp-content\/uploads\/2023\/05\/logo-grande.png\",\"contentUrl\":\"https:\/\/www.reselhost.mx\/kb\/wp-content\/uploads\/2023\/05\/logo-grande.png\",\"width\":200,\"height\":200,\"caption\":\"Reselhost LLC\"},\"image\":{\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/reselhost\",\"https:\/\/x.com\/reselhost\",\"https:\/\/www.instagram.com\/reselhost\",\"https:\/\/www.linkedin.com\/in\/reselhost\",\"https:\/\/www.youtube.com\/@reselhost\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#\/schema\/person\/d9a5924efda55954d13bd172c785f862\",\"name\":\"soporte\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/www.reselhost.mx\/kb\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g\",\"caption\":\"soporte\"},\"sameAs\":[\"https:\/\/www.intelhost.com.mx\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Optimizar Base de Datos MySQL por phpMyAdmin cPanel - Reselhost","description":"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel Base de Conocimientos con Web Hosting y Reseller Hosting Gratuito.","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:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/","og_locale":"es_ES","og_type":"article","og_title":"Optimizar Base de Datos MySQL por phpMyAdmin cPanel - Reselhost","og_description":"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel Base de Conocimientos con Web Hosting y Reseller Hosting Gratuito.","og_url":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/","og_site_name":"Reselhost","article_publisher":"https:\/\/www.facebook.com\/reselhost","article_published_time":"2021-07-25T13:38:52+00:00","og_image":[{"url":"https:\/\/www.intelhost.com\/img\/phpmyadmin-icon.gif","type":"","width":"","height":""}],"author":"soporte","twitter_card":"summary_large_image","twitter_creator":"@reselhost","twitter_site":"@reselhost","twitter_misc":{"Escrito por":"soporte","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#article","isPartOf":{"@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/"},"author":{"name":"soporte","@id":"https:\/\/www.reselhost.mx\/kb\/#\/schema\/person\/d9a5924efda55954d13bd172c785f862"},"headline":"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel","datePublished":"2021-07-25T13:38:52+00:00","mainEntityOfPage":{"@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/"},"wordCount":83,"commentCount":0,"publisher":{"@id":"https:\/\/www.reselhost.mx\/kb\/#organization"},"image":{"@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif","keywords":["cPanel","MySQL"],"articleSection":["Base de Datos MySQL"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/","url":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/","name":"Optimizar Base de Datos MySQL por phpMyAdmin cPanel - Reselhost","isPartOf":{"@id":"https:\/\/www.reselhost.mx\/kb\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage"},"image":{"@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif","datePublished":"2021-07-25T13:38:52+00:00","description":"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel Base de Conocimientos con Web Hosting y Reseller Hosting Gratuito.","breadcrumb":{"@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#primaryimage","url":"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif","contentUrl":"https:\/\/www.reselhost.com\/img\/phpmyadmin-icon.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/www.reselhost.mx\/kb\/como-optimizar-la-base-de-datos-mysql-a-traves-de-phpmyadmin-en-cpanel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.reselhost.mx\/kb\/"},{"@type":"ListItem","position":2,"name":"C\u00f3mo optimizar la Base de Datos MySQL a trav\u00e9s de phpMyAdmin en cPanel"}]},{"@type":"WebSite","@id":"https:\/\/www.reselhost.mx\/kb\/#website","url":"https:\/\/www.reselhost.mx\/kb\/","name":"Reselhost","description":"Base de Conocimientos Reseller Hosting","publisher":{"@id":"https:\/\/www.reselhost.mx\/kb\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.reselhost.mx\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/www.reselhost.mx\/kb\/#organization","name":"Reselhost LLC","url":"https:\/\/www.reselhost.mx\/kb\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.reselhost.mx\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.reselhost.mx\/kb\/wp-content\/uploads\/2023\/05\/logo-grande.png","contentUrl":"https:\/\/www.reselhost.mx\/kb\/wp-content\/uploads\/2023\/05\/logo-grande.png","width":200,"height":200,"caption":"Reselhost LLC"},"image":{"@id":"https:\/\/www.reselhost.mx\/kb\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/reselhost","https:\/\/x.com\/reselhost","https:\/\/www.instagram.com\/reselhost","https:\/\/www.linkedin.com\/in\/reselhost","https:\/\/www.youtube.com\/@reselhost"]},{"@type":"Person","@id":"https:\/\/www.reselhost.mx\/kb\/#\/schema\/person\/d9a5924efda55954d13bd172c785f862","name":"soporte","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/www.reselhost.mx\/kb\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e889bfe45e57e333934f731d2f44d88bc7a50c1d0b8c9b5c48e9a69b5a775459?s=96&d=mm&r=g","caption":"soporte"},"sameAs":["https:\/\/www.intelhost.com.mx\/kb"]}]}},"_links":{"self":[{"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/posts\/181","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/comments?post=181"}],"version-history":[{"count":0,"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/posts\/181\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/media?parent=181"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/categories?post=181"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.reselhost.mx\/kb\/wp-json\/wp\/v2\/tags?post=181"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}