{"id":5609,"date":"2019-06-04T06:19:51","date_gmt":"2019-06-04T06:19:51","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=5609"},"modified":"2019-06-04T06:19:51","modified_gmt":"2019-06-04T06:19:51","slug":"learn-to-repair-and-optimize-mysql-database-using-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/","title":{"rendered":"Learn To Repair And Optimize MySQL Database using phpMyAdmin"},"content":{"rendered":"

Optimize MySQL Databases.<\/h2>\n

Databases can grow to very large space, particularly for the sites that receive huge traffic and contain a large amount of content. Thus, optimizing databases after every particular time period helps to improve your website performance.<\/p>\n

Follow the below steps to optimize a MySQL\u00a0 database :<\/p>\n

1. Log in to your cPanel account.<\/p>\n

2. Go to the Databases section on the cPanel home screen and click on phpMyAdmin.<\/p>\n

\"DB<\/a><\/p>\n

Now you can see the phpMyAdmin administrator page appeared in a new window.<\/p>\n

3. On the left-hand side, click on the name of the database file that you want to optimize.<\/p>\n

For example, the below image shows the example_wordpress database is been selected.<\/p>\n

\"DB<\/a><\/p>\n

4. In the right-hand side of the panel, select the check boxes for the tables in the database that you wish to optimize.<\/p>\n

Tip: If you want to select all the tables at once, select the Check All checkbox.<\/div>\n

 <\/p>\n

\"DB<\/a><\/p>\n

5. In the drop-down list box of With Selected, select the Optimize table. The phpMyAdmin will inform you whether or not your optimization process is successful.<\/p>\n

Steps to Repair MySQL databases –<\/h3>\n

Your databases can get corrupted due to the number of reasons, like software defects, hardware issues, or even due to natural calamities. In such condition, you can repair database tables using phpMyAdmin.<\/p>\n

To repair MySQL database, follow the below steps :<\/p>\n

1. Log in to cPanel account.<\/p>\n

2. Go to the Databases section on the cPanel home screen and click on phpMyAdmin.<\/p>\n

3. On the left-hand side of the panel, click on the name of the database that you want to repair.<\/p>\n

For example : image shows that example_wordpress database is selected :<\/p>\n

\"DB<\/a><\/p>\n

4. In the right-hand side of the panel, check the boxes of the tables for those you want to perform repair task.<\/p>\n

\"DB<\/a><\/p>\n

Note: You can select all the databases at once, by selecting the Check All checkbox.<\/div>\n

5. In the drop-down list box of With Selected, select Repair table. The phpMyAdmin will inform you whether or not your repair process is successful.<\/p>\n

That’s it!<\/p>\n

You are done.<\/p>\n

Also Read :<\/strong><\/p>\n

1. How to import MySQL tables using phpMyAdmin?<\/a><\/strong><\/p>\n

2.\u00a0How to Backup an SQL Server Database?<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Optimize MySQL Databases. Databases can grow to very large space, particularly for the sites that receive huge traffic and contain a large amount of content. Thus, optimizing databases after every particular time period helps to improve your website performance. Follow the below steps to optimize a MySQL\u00a0 database : 1. Log in to your cPanel […]<\/p>\n","protected":false},"author":18,"featured_media":5616,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[230],"tags":[722,723],"class_list":["post-5609","post","type-post","status-publish","format-standard","has-post-thumbnail","placeholder-for-hentry","category-database","tag-optimize-mysql","tag-repair-mysql"],"yoast_head":"\nLearn To Repair And Optimize MySQL Database using phpMyAdmin - Web Hosting FAQs by MilesWeb<\/title>\n<meta name=\"description\" content=\"This article will guide you on how you can repair and optimize MySQL database using 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:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Learn To Repair And Optimize MySQL Database using phpMyAdmin - Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"og:description\" content=\"This article will guide you on how you can repair and optimize MySQL database using phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2019-06-04T06:19:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"445\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Sonam Wagh\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sonam Wagh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/\",\"name\":\"Learn To Repair And Optimize MySQL Database using phpMyAdmin - Web Hosting FAQs by MilesWeb\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png\",\"datePublished\":\"2019-06-04T06:19:51+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\"},\"description\":\"This article will guide you on how you can repair and optimize MySQL database using phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png\",\"width\":800,\"height\":445,\"caption\":\"Repair and Optimize MySQL\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Learn To Repair And Optimize MySQL Database using phpMyAdmin\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\",\"name\":\"Web Hosting FAQs by MilesWeb\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4\",\"name\":\"Sonam Wagh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g\",\"caption\":\"Sonam Wagh\"},\"description\":\"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Learn To Repair And Optimize MySQL Database using phpMyAdmin - Web Hosting FAQs by MilesWeb","description":"This article will guide you on how you can repair and optimize MySQL database using 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:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"Learn To Repair And Optimize MySQL Database using phpMyAdmin - Web Hosting FAQs by MilesWeb","og_description":"This article will guide you on how you can repair and optimize MySQL database using phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2019-06-04T06:19:51+00:00","og_image":[{"width":800,"height":445,"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png","type":"image\/png"}],"author":"Sonam Wagh","twitter_misc":{"Written by":"Sonam Wagh","Estimated reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/","name":"Learn To Repair And Optimize MySQL Database using phpMyAdmin - Web Hosting FAQs by MilesWeb","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png","datePublished":"2019-06-04T06:19:51+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4"},"description":"This article will guide you on how you can repair and optimize MySQL database using phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2019\/06\/Repair-And-Optimize-min.png","width":800,"height":445,"caption":"Repair and Optimize MySQL"},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/learn-to-repair-and-optimize-mysql-database-using-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"Learn To Repair And Optimize MySQL Database using phpMyAdmin"}]},{"@type":"WebSite","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/","name":"Web Hosting FAQs by MilesWeb","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Person","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/dc645d02823c86e07e53798ebe02c6f4","name":"Sonam Wagh","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9cb2cf6ae11d7625ef6417ef8e84ba25?s=96&d=blank&r=g","caption":"Sonam Wagh"},"description":"With an interest in doing something creative daily, Sonam works as a Digital Marketing Executive. She likes to write technical blogs related to web hosting, digital marketing, and other IT topics. She also likes to spend her leisure time on social media to find different strategies for client engagement.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/sonam\/"}]}},"views":845,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/5609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/users\/18"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=5609"}],"version-history":[{"count":2,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/5609\/revisions"}],"predecessor-version":[{"id":5617,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/5609\/revisions\/5617"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media\/5616"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=5609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=5609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=5609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}