{"id":3764,"date":"2021-12-31T13:13:48","date_gmt":"2021-12-31T13:13:48","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=3764"},"modified":"2021-12-31T13:14:25","modified_gmt":"2021-12-31T13:14:25","slug":"3764","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/3764\/","title":{"rendered":"Why &#038; How to Optimise &#038; Repair MySQL Database using phpMyAdmin in cPanel"},"content":{"rendered":"<p>In this article will understand the way to optimize and repair MySQL Database using phpMyAdmin in cPanel.<\/p>\n<p>Why Optimise and Repair MySQL Database?<\/p>\n<p>Before moving further on the method of optimizing and repairing the MySQL database allow us to perceive why it&#8217;s necessary to do so:<\/p>\n<p>1. Databases develop to a substantial extent once a web site receives a lot of traffic and features a lot of data. As a result, it becomes important to optimize databases at regular periods to boost the site\u2019s performance.<\/p>\n<p>2. The records may be destroyed for a variety of reasons, as well as programming vulnerabilities, equipment problems, and even environmental disasters. In such things, you&#8217;ll be able to use phpMyAdmin to repair database tables.<\/p>\n<p>Now, let us see the procedure:<\/p>\n<p>1. Log in to the <strong>cPanel<\/strong> account.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3765\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-1-250x300.png\" alt=\"db-php-1\" width=\"307\" height=\"368\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-1-250x300.png 250w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-1.png 307w\" sizes=\"auto, (max-width: 307px) 100vw, 307px\" \/><\/p>\n<p>2. After that select the <strong>Databases<\/strong> option and click on <strong>phpMyAdmin<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3766\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-2-300x50.png\" alt=\"db-php-2\" width=\"694\" height=\"116\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-2-300x50.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-2.png 694w\" sizes=\"auto, (max-width: 694px) 100vw, 694px\" \/><\/p>\n<p>3. A new page of <strong>phpMyAdmin<\/strong> will get appear to you.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3767\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-3-169x300.png\" alt=\"db-php-3\" width=\"217\" height=\"385\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-3-169x300.png 169w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-3.png 217w\" sizes=\"auto, (max-width: 217px) 100vw, 217px\" \/><\/p>\n<p>4. First of all from the left-hand side select the <strong>structure<\/strong> and you will be able to see a <strong>list of tables<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3768\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-4-300x159.png\" alt=\"db-php-4\" width=\"895\" height=\"474\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-4-300x159.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-4-768x407.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-4.png 895w\" sizes=\"auto, (max-width: 895px) 100vw, 895px\" \/><\/p>\n<p>5. Now, looking on the operation you wish to carry out, choose the databases and put a tick mark in front of the names. You&#8217;ll be able to choose all at a time by selecting the \u201c<strong>Check all<\/strong>\u201d option.<\/p>\n<p>6. Then you have to click on the drop-down arrow next to the tab \u201c<strong>With selected<\/strong>\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3769\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-5-300x145.png\" alt=\"db-php-5\" width=\"887\" height=\"430\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-5-300x145.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-5-768x372.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-5.png 887w\" sizes=\"auto, (max-width: 887px) 100vw, 887px\" \/><\/p>\n<p>7. You will get a list of options. Choose \u201c<strong>Optimize table<\/strong>\u201d if you want to optimize the table and choose \u201c<strong>Repair table<\/strong>\u201d if you want to repair the table.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3770\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-6-300x29.png\" alt=\"db-php-6\" width=\"1024\" height=\"100\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-6-300x29.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-6-768x75.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-6.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-3771\" src=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-7-300x28.png\" alt=\"db-php-7\" width=\"1024\" height=\"96\" srcset=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-7-300x28.png 300w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-7-768x72.png 768w, https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-7.png 1024w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>8. phpMyAdmin can allow you to apprehend whether or not or not the optimization and repair were <strong>successful<\/strong>. You&#8217;ll be able to see this as shown within the pictures given below.<\/p>\n<p>This tutorial can show you the way to optimize and repair your MySQL database using phpMyAdmin in cPanel. Hopefully, you were ready to comprehend everything. Check out Ownwebservers Knowledge Base for a lot of helpful tutorials. We tend to even have an skilled team available to help you 24 hours day, seven days a week.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article will understand the way to optimize and repair MySQL Database using phpMyAdmin in cPanel. Why Optimise and Repair MySQL Database? Before moving further on the method of optimizing and repairing the MySQL database allow us to perceive why it&#8217;s necessary to do so: 1. Databases develop to a substantial extent once a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17,24],"tags":[],"class_list":["post-3764","post","type-post","status-publish","format-standard","hentry","category-mysql","category-web-hosting"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Why &amp; How to Optimise &amp; Repair MySQL Database using phpMyAdmin in cPanel - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/3764\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Why &amp; How to Optimise &amp; Repair MySQL Database using phpMyAdmin in cPanel - OWS KB\" \/>\n<meta property=\"og:description\" content=\"In this article will understand the way to optimize and repair MySQL Database using phpMyAdmin in cPanel. Why Optimise and Repair MySQL Database? Before moving further on the method of optimizing and repairing the MySQL database allow us to perceive why it&#8217;s necessary to do so: 1. Databases develop to a substantial extent once a [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/3764\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-12-31T13:13:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-31T13:14:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-1-250x300.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"1 minute\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3764\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/12\/db-php-1.png\",\"width\":307,\"height\":368,\"caption\":\"db-php-1\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3764\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/3764\/\",\"name\":\"Why & How to Optimise & Repair MySQL Database using phpMyAdmin in cPanel - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/3764\/#primaryimage\"},\"datePublished\":\"2021-12-31T13:13:48+00:00\",\"dateModified\":\"2021-12-31T13:14:25+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/3764\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/3764\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3764\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/3764\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/3764\/\",\"name\":\"Why &#038; How to Optimise &#038; Repair MySQL Database using phpMyAdmin in cPanel\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3764","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=3764"}],"version-history":[{"count":2,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3764\/revisions"}],"predecessor-version":[{"id":3773,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/3764\/revisions\/3773"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=3764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=3764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=3764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}