{"id":1109,"date":"2018-07-21T18:01:19","date_gmt":"2018-07-21T16:01:19","guid":{"rendered":"https:\/\/assistance.groupemagiconline.com\/?post_type=ht_kb&#038;p=1109"},"modified":"2020-02-11T15:52:21","modified_gmt":"2020-02-11T14:52:21","slug":"plesk-reparer-ma-base-de-donnees-mysql","status":"publish","type":"ht_kb","link":"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/plesk-reparer-ma-base-de-donnees-mysql\/","title":{"rendered":"Plesk: Repair my MySQL database"},"content":{"rendered":"<p>In this guide we will see how to repair a MySQL database.<\/p>\n    \t\t<div class=\"hts-messages hts-messages--info  hts-messages--withtitle hts-messages--withicon\"   >\r\n    \t\t\t<span class=\"hts-messages__title\">Note<\/span>    \t\t\t    \t\t\t\t<p>\r\n    \t\t\t\t\tThis guide is dedicated only to our subscribers who have subscribed to the old <a href=\"https:\/\/assistance.groupemagiconline.com\/en\/knowledge-base\/upgrade-mon-hebergement-mutualise\/\">shared hosting<\/a> Plesk (SMART, DISCOUNT, PRO and SECURE offer).    \t\t\t\t<\/p>\r\n    \t\t\t    \t\t\t\r\n    \t\t<\/div><!-- \/.ht-shortcodes-messages -->\r\n    \t\t\n<h2>Why repair a MySQL database?<\/h2>\n<p>This is when you have an error on your website and you are sure that the database connection settings are correct.<\/p>\n<h2>Repairing a MySQL database<\/h2>\n<p>The first thing to do is to go to <a href=\"https:\/\/cp.magic.fr\/\">your client interface<\/a>\u00a0which you can find the link to on our showcase site. Once there, click on Plesk &gt; My Plesk (Manage my subscription) &gt; menu\u00a0<strong>Databases<\/strong>.<\/p>\n<p>There are two methods to repair your database.<\/p>\n<h2>First method<\/h2>\n<p>Follow the link\u00a0<strong>Check and repair<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-564\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1.jpg\" alt=\"access your Plesk space to repair the database\" width=\"923\" height=\"465\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1.jpg 923w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1-300x151.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1-768x387.jpg 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1-50x25.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1-60x30.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-1-100x50.jpg 100w\" sizes=\"(max-width: 923px) 100vw, 923px\" \/><\/p>\n<p>The task can take a long time if the database is too full.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-565\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-2.jpg\" alt=\"launch the repair from plesk\" width=\"372\" height=\"168\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-2.jpg 372w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-2-300x135.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-2-50x23.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-2-60x27.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-2-100x45.jpg 100w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/p>\n<p>Once the database is checked, Plesk will give you the result of the repair.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-563\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-3.jpg\" alt=\"repair performed\" width=\"372\" height=\"130\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-3.jpg 372w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-3-300x105.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-3-50x17.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-3-60x21.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-3-100x35.jpg 100w\" sizes=\"(max-width: 372px) 100vw, 372px\" \/><\/p>\n<h2>Second method<\/h2>\n<p>Follow the link\u00a0<strong>phpMyAdmin<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-562\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4.jpg\" alt=\"repair your database from PHPMyadmin\" width=\"923\" height=\"465\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4.jpg 923w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4-300x151.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4-768x387.jpg 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4-50x25.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4-60x30.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-4-100x50.jpg 100w\" sizes=\"(max-width: 923px) 100vw, 923px\" \/><\/p>\n<p>Check the case\u00a0<strong>Check all<\/strong>\u00a0then select\u00a0<strong>Repairing the table<\/strong>.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-561\" src=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5.jpg\" alt=\"Launching a repair from phpmyadmin\" width=\"1009\" height=\"584\" srcset=\"https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5.jpg 1009w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5-300x174.jpg 300w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5-768x445.jpg 768w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5-50x29.jpg 50w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5-60x35.jpg 60w, https:\/\/assistance.groupemagiconline.com\/wp-content\/uploads\/2018\/04\/Reparer-ma-base-de-donnees-5-100x58.jpg 100w\" sizes=\"(max-width: 1009px) 100vw, 1009px\" \/><\/p>\n<p>The interface will show you the repaired tables, as well as the tables that do not support the\u00a0<strong>repair<\/strong>.<\/p>","protected":false},"excerpt":{"rendered":"<p>In this guide we will see how to repair a MySQL database. Why repair a MySQL database? It is when you have an error on your website and you are sure that the database connection settings are correct. Repairing a database...<\/p>","protected":false},"author":52,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":""},"ht-kb-category":[728],"ht-kb-tag":[669],"class_list":["post-1109","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-serveur-plesk","ht_kb_tag-site-web"],"_links":{"self":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/1109","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/users\/52"}],"replies":[{"embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/comments?post=1109"}],"version-history":[{"count":0,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb\/1109\/revisions"}],"wp:attachment":[{"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/media?parent=1109"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-category?post=1109"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/assistance.groupemagiconline.com\/en\/wp-json\/wp\/v2\/ht-kb-tag?post=1109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}