{"id":11576,"date":"2021-09-15T08:59:25","date_gmt":"2021-09-15T08:59:25","guid":{"rendered":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/?p=11576"},"modified":"2024-04-24T06:55:25","modified_gmt":"2024-04-24T05:55:25","slug":"repair-mysql-database-cpanel-whm-phpmyadmin","status":"publish","type":"post","link":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/","title":{"rendered":"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?"},"content":{"rendered":"

Although rare, the tables and indexes of your databases can get damaged or corrupted, which means you need to rebuild them. A simple way to fix it is by repairing the database.<\/p>\n

\n
Repair MySQL Database<\/div>\n
\n
via cPanel<\/div>\n
via WHM<\/div>\n
via phpMyAdmin<\/div>\n<\/div>\n<\/div>\n

To Repair MySQL Database via cPanel<\/h2>\n

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

2. Go to the DATABASES<\/strong> section and click on MySQL\u00ae Databases<\/strong>.<\/p>\n

\"\"<\/p>\n

3. Find the Modify Databases<\/strong> section and<\/p>\n

    \n
  • select the database from the drop-down\u00a0list of the Repair Database<\/strong> field.<\/li>\n
  • Click on\u00a0the Repair Database<\/strong> button.<\/li>\n<\/ul>\n

    \"\"<\/p>\n

    The cPanel will display the\u00a0message:\u00a0Repair Complete!<\/em><\/p>\n

    To Repair MySQL Database via WHM<\/h2>\n

    1. Log in to the WHM panel with your root account.<\/p>\n

    2. Select the SQL Services<\/strong> in the navigation menu.<\/p>\n

    \"\"<\/p>\n

    3. Click on Repair a MySQL Database<\/strong>.<\/p>\n

    \"\"<\/p>\n

    A list of databases will appear.<\/p>\n

    4. Select the database you want to repair from the list and click the Repair Database<\/strong> button.<\/p>\n

    \"\"<\/p>\n

    It will take a while for the system to complete the process, depending on the database. After repairing the database, the system will show a success message:<\/p>\n

    \"\"<\/p>\n

    To Repair MySQL Database via phpMyAdmin<\/h2>\n

    Users can access phpMyAdmin via cPanel and WHM interfaces.<\/p>\n

    To Open phpMyAdmin from cPanel<\/h3>\n

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

    2. Scroll to the DATABASES<\/strong> section and click on phpMyAdmin<\/strong>.\"\"<\/p>\n

    To Open phpMyAdmin from WHM<\/h3>\n

    1. Log in to the WHM panel with\u00a0your root account.<\/p>\n

    2. Select the SQL Services<\/strong> in the navigation menu.<\/p>\n

    \"\"<\/p>\n

    3. Click on phpMyAdmin<\/strong>.<\/p>\n

    \"\"<\/p>\n

    Once you have opened the phpMyAdmin module, you can follow these steps to repair a database.<\/p>\n

    1. Click the Databases<\/strong> tab and\u00a0select a database from the list.<\/p>\n

    \"\"<\/p>\n

    A list of tables of the database will appear.<\/p>\n

    2. Tick the Check all<\/strong> box to select all tables of the database.<\/p>\n

    There is a field with a list box beside it saying-\u00a0With selected:<\/strong><\/em><\/p>\n

    3. Open the list and click the Repair table<\/strong> option.<\/p>\n

    \"\"<\/p>\n

    The phpMyAdmin will execute the query for the database tables. After some time, a success message along with a brief report will appear indicating the database tables have been repaired.<\/p>\n

    \"\"<\/p>\n

    \n
    \n
    \n
    <\/div>\n<\/div>\n<\/div>\n
    \n

    Warning<\/strong>: In some cases, repair operation on a database may cause data loss. As a precaution, we recommend you take a backup of the database before performing a repair operation.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

    Although rare, the tables and indexes of your databases can get damaged or corrupted, which means you need to rebuild them. A simple way to fix it is by repairing the database. Repair MySQL Database via cPanel via WHM via phpMyAdmin To Repair MySQL Database via cPanel 1. Log in to your cPanel account. 2. […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9,947,925,229],"tags":[152,1536,1142,616,723,2461,2462,175],"class_list":["post-11576","post","type-post","status-publish","format-standard","placeholder-for-hentry","category-cpanel-faq","category-mysql","category-phpmyadmin","category-whm","tag-cpanel","tag-database-management","tag-mysql-database-table","tag-phpmyadmin","tag-repair-mysql","tag-repair-mysql-database","tag-repair-mysql-tables","tag-whm"],"yoast_head":"\nHow to Repair MySQL Database via cPanel, WHM and phpMyAdmin?<\/title>\n<meta name=\"description\" content=\"On the off-chance your database is corrupted or damaged, there is a way to fix it. One way is to repair the MySQL database via cPanel, WHM or 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\/repair-mysql-database-cpanel-whm-phpmyadmin\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?\" \/>\n<meta property=\"og:description\" content=\"On the off-chance your database is corrupted or damaged, there is a way to fix it. One way is to repair the MySQL database via cPanel, WHM or phpMyAdmin.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/\" \/>\n<meta property=\"og:site_name\" content=\"Web Hosting FAQs by MilesWeb\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-15T08:59:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-04-24T05:55:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png\" \/>\n<meta name=\"author\" content=\"Prasad Khartadkar\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prasad Khartadkar\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/repair-mysql-database-cpanel-whm-phpmyadmin\/\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/\",\"name\":\"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?\",\"isPartOf\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png\",\"datePublished\":\"2021-09-15T08:59:25+00:00\",\"dateModified\":\"2024-04-24T05:55:25+00:00\",\"author\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e\"},\"description\":\"On the off-chance your database is corrupted or damaged, there is a way to fix it. One way is to repair the MySQL database via cPanel, WHM or phpMyAdmin.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#primaryimage\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png\",\"contentUrl\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png\",\"width\":965,\"height\":186},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Repair MySQL Database via cPanel, WHM and 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\/c9138a9488172a8d0aa2d4f40878d83e\",\"name\":\"Prasad Khartadkar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g\",\"caption\":\"Prasad Khartadkar\"},\"description\":\"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.\",\"url\":\"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?","description":"On the off-chance your database is corrupted or damaged, there is a way to fix it. One way is to repair the MySQL database via cPanel, WHM or 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\/repair-mysql-database-cpanel-whm-phpmyadmin\/","og_locale":"en_GB","og_type":"article","og_title":"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?","og_description":"On the off-chance your database is corrupted or damaged, there is a way to fix it. One way is to repair the MySQL database via cPanel, WHM or phpMyAdmin.","og_url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/","og_site_name":"Web Hosting FAQs by MilesWeb","article_published_time":"2021-09-15T08:59:25+00:00","article_modified_time":"2024-04-24T05:55:25+00:00","og_image":[{"url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png","type":"","width":"","height":""}],"author":"Prasad Khartadkar","twitter_misc":{"Written by":"Prasad Khartadkar","Estimated reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/","name":"How to Repair MySQL Database via cPanel, WHM and phpMyAdmin?","isPartOf":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#primaryimage"},"image":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#primaryimage"},"thumbnailUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png","datePublished":"2021-09-15T08:59:25+00:00","dateModified":"2024-04-24T05:55:25+00:00","author":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/c9138a9488172a8d0aa2d4f40878d83e"},"description":"On the off-chance your database is corrupted or damaged, there is a way to fix it. One way is to repair the MySQL database via cPanel, WHM or phpMyAdmin.","breadcrumb":{"@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#primaryimage","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png","contentUrl":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-content\/uploads\/2021\/03\/mysqldb.png","width":965,"height":186},{"@type":"BreadcrumbList","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/repair-mysql-database-cpanel-whm-phpmyadmin\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/"},{"@type":"ListItem","position":2,"name":"How to Repair MySQL Database via cPanel, WHM and 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\/c9138a9488172a8d0aa2d4f40878d83e","name":"Prasad Khartadkar","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fafb102a39aa8f8d38a11f3e2dcfa746?s=96&d=blank&r=g","caption":"Prasad Khartadkar"},"description":"Prasad is a business grad specialized in Marketing. He has garnered experience as a technical content writer and a digital marketer that he brings out in his work. He likes reading classics and travel in his free time.","url":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/author\/prasad-khartadkar\/"}]}},"views":406,"_links":{"self":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11576","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\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/comments?post=11576"}],"version-history":[{"count":4,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11576\/revisions"}],"predecessor-version":[{"id":15547,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/posts\/11576\/revisions\/15547"}],"wp:attachment":[{"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/media?parent=11576"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/categories?post=11576"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.milesweb.co.uk\/hosting-faqs\/wp-json\/wp\/v2\/tags?post=11576"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}