{"id":3045,"date":"2012-02-29T14:53:38","date_gmt":"2012-02-29T12:53:38","guid":{"rendered":"http:\/\/localhost\/helpcentre\/?p=3045"},"modified":"2026-01-30T10:34:40","modified_gmt":"2026-01-30T08:34:40","slug":"repair-optimize-mysql-database","status":"publish","type":"post","link":"https:\/\/xneelo.co.za\/help-centre\/website\/repair-optimize-mysql-database\/","title":{"rendered":"How to repair or optimise a database via konsoleH"},"content":{"rendered":"<p>Databases can become corrupted, often due to software or hardware issues. Additionally, databases can grow very large and can benefit from periodic optimisation. These tables can easily be <strong>repaired<\/strong>\u00a0or <strong>optimised<\/strong> using <strong>phpMyAdmin<\/strong> in the konsoleH control panel.<\/p>\n<h2>Access phpMyAdmin in konsoleH<\/h2>\n<div id=\"action_points\">\n<ol>\n<li>Browse to <strong><a href=\"http:\/\/secure.konsoleh.co.za\" target=\"_blank\" rel=\"noopener noreferrer\">konsoleH<\/a><\/strong> and log in (<a href=\"https:\/\/xneelo.co.za\/help-centre\/accounts-and-payments\/konsoleh-access-levels\/\" target=\"_blank\" rel=\"noopener noreferrer\">Admin or Domain level<\/a>)<\/li>\n<li>Admin level: Select or search for a domain name in the <b>Hosting Service<\/b>\u00a0tab<\/li>\n<li>Select <b>Manage Services<\/b><\/li>\n<li>Select <b>Manage MySQL<\/b><\/li>\n<li>Select a database<\/li>\n<li>Click\u00a0<b>phpMyAdmin<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18209 size-full alignleft\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1-e1557733394465.png\" alt=\"\" width=\"819\" height=\"193\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1-e1557733394465.png 819w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1-e1557733394465-300x71.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1-e1557733394465-768x181.png 768w\" sizes=\"auto, (max-width: 819px) 100vw, 819px\" \/><\/a><\/b><\/li>\n<li>Select the database from the <b>Databases<\/b>\u00a0list in phpMyAdmin<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-20562\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database.png\" alt=\"\" width=\"2050\" height=\"436\" srcset=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database.png 2050w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database-300x64.png 300w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database-1024x218.png 1024w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database-768x163.png 768w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database-1536x327.png 1536w, https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database-2048x436.png 2048w\" sizes=\"auto, (max-width: 2050px) 100vw, 2050px\" \/><\/a><\/li>\n<li>From the list of database tables, check the boxes next to the tables that need to be repaired or optimised<\/li>\n<li>At the bottom of the window (below the list of tables), click the drop-down menu at <b>With Selected<\/b>\n<ul>\n<li>Choose either <strong>Repair<\/strong> or <strong>Optimize\u00a0<\/strong>according to your needs<\/li>\n<\/ul>\n<\/li>\n<\/ol>\n<\/div>\n<p>Once this has run you should get a message confirming that the relevant table has been repaired.<\/p>\n","protected":false,"plain":"Databases can become corrupted, often due to software or hardware issues. Additionally, databases can grow very large and can benefit from periodic optimisation. These tables can easily be <strong>repaired<\/strong>\u00a0or <strong>optimised<\/strong> using <strong>phpMyAdmin<\/strong> in the konsoleH control panel.\r\n<h2>Access phpMyAdmin in konsoleH<\/h2>\r\n<div id=\"action_points\">\r\n<ol>\r\n \t<li>Browse to <strong><a href=\"http:\/\/secure.konsoleh.co.za\" target=\"_blank\" rel=\"noopener noreferrer\">konsoleH<\/a><\/strong> and log in (<a href=\"https:\/\/xneelo.co.za\/help-centre\/accounts-and-payments\/konsoleh-access-levels\/\" target=\"_blank\" rel=\"noopener noreferrer\">Admin or Domain level<\/a>)<\/li>\r\n \t<li>Admin level: Select or search for a domain name in the <b>Hosting Service<\/b>\u00a0tab<\/li>\r\n \t<li>Select <b>Manage Services<\/b><\/li>\r\n \t<li>Select <b>Manage MySQL<\/b><\/li>\r\n \t<li>Select a database<\/li>\r\n \t<li>Click\u00a0<b>phpMyAdmin<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1.png\"><img class=\"wp-image-18209 size-full alignleft\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2017\/01\/kh-manage-mysql1-e1557733394465.png\" alt=\"\" width=\"819\" height=\"193\" \/><\/a><\/b><\/li>\r\n \t<li>Select the database from the <b>Databases<\/b>\u00a0list in phpMyAdmin<a href=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database.png\"><img class=\"alignnone size-full wp-image-20562\" src=\"https:\/\/xneelo.co.za\/help-centre\/wp-content\/uploads\/2012\/02\/phpmyadmin-database.png\" alt=\"\" width=\"2050\" height=\"436\" \/><\/a><\/li>\r\n \t<li>From the list of database tables, check the boxes next to the tables that need to be repaired or optimised<\/li>\r\n \t<li>At the bottom of the window (below the list of tables), click the drop-down menu at <b>With Selected<\/b>\r\n<ul>\r\n \t<li>Choose either <strong>Repair<\/strong> or <strong>Optimize\u00a0<\/strong>according to your needs<\/li>\r\n<\/ul>\r\n<\/li>\r\n<\/ol>\r\n<\/div>\r\nOnce this has run you should get a message confirming that the relevant table has been repaired."},"excerpt":{"rendered":"<p>Databases associated with your hosting account can easily be repaired if they become corrupt or optimised if they are large using phpMyAdmin in konsoleH.<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"lsx_disable_title":"0","_relevanssi_hide_post":"","_relevanssi_hide_content":"","_relevanssi_pin_for_all":"","_relevanssi_pin_keywords":"","_relevanssi_unpin_keywords":"","_relevanssi_related_keywords":"","_relevanssi_related_include_ids":"","_relevanssi_related_exclude_ids":"","_relevanssi_related_no_append":"","_relevanssi_related_not_related":"","_relevanssi_related_posts":"","_relevanssi_noindex_reason":"","footnotes":""},"categories":[180,166],"tags":[18135,657,755],"topics":[10403],"class_list":["post-3045","post","type-post","status-publish","format-standard","hentry","category-mysql","category-website","tag-repair-database","tag-phpmyadmin","tag-optimise-database","topics-konsoleh-tools"],"acf":[],"additional_meta":{"category_title":[{"term_id":180,"name":"MySQL","slug":"mysql","term_group":0,"term_taxonomy_id":180,"taxonomy":"category","description":"Using MySQL for web applications ","parent":168,"count":9,"filter":"raw","term_order":"92","cat_ID":180,"category_count":9,"category_description":"Using MySQL for web applications ","cat_name":"MySQL","category_nicename":"mysql","category_parent":168},{"term_id":166,"name":"Website","slug":"website","term_group":0,"term_taxonomy_id":166,"taxonomy":"category","description":"About your Website(s)","parent":0,"count":169,"filter":"raw","term_order":"120","cat_ID":166,"category_count":169,"category_description":"About your Website(s)","cat_name":"Website","category_nicename":"website","category_parent":0}],"tag_title":[{"term_id":18135,"name":"repair database","slug":"repair-database","term_group":0,"term_taxonomy_id":18135,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw","term_order":"2079"},{"term_id":657,"name":"phpmyadmin","slug":"phpmyadmin","term_group":0,"term_taxonomy_id":657,"taxonomy":"post_tag","description":"","parent":0,"count":9,"filter":"raw","term_order":"2776"},{"term_id":755,"name":"optimise database","slug":"optimise-database","term_group":0,"term_taxonomy_id":755,"taxonomy":"post_tag","description":"","parent":0,"count":4,"filter":"raw","term_order":"2779"}]},"featured_image_src":null,"author_info":{"display_name":"marketing","author_link":"https:\/\/xneelo.co.za\/help-centre\/author\/marketing\/","author_avatar":"https:\/\/secure.gravatar.com\/avatar\/a6ea315e112423b2b955cb020fbce2b0835956c6ad85ff0f13f1db298977eaaa?s=96&d=mm&r=g"},"_links":{"self":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/comments?post=3045"}],"version-history":[{"count":0,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/posts\/3045\/revisions"}],"wp:attachment":[{"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/media?parent=3045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/categories?post=3045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/tags?post=3045"},{"taxonomy":"topics","embeddable":true,"href":"https:\/\/xneelo.co.za\/help-centre\/wp-json\/wp\/v2\/topics?post=3045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}