{"id":4867,"date":"2020-03-12T15:56:07","date_gmt":"2020-03-12T19:56:07","guid":{"rendered":"https:\/\/www.globo.tech\/learning-center\/?p=4867"},"modified":"2020-03-12T15:59:47","modified_gmt":"2020-03-12T19:59:47","slug":"how-to-check-and-repair-mysql-databases","status":"publish","type":"post","link":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/","title":{"rendered":"How to check and repair MySQL Databases"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large is-style-default\"><img loading=\"lazy\" decoding=\"async\" width=\"1200\" height=\"628\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg\" alt=\"How to check and repair MySQL Databases.\" class=\"wp-image-4868\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">How to check and repair MySQL Databases<\/h2>\n\n\n\n<p>You will need know how to check and repair MySQL databases or tables when you troubleshoot your <a href=\"https:\/\/www.globo.tech\/dedicated-server-hosting\">website<\/a> as they may have become corrupt. The mysqlcheck command is a maintenance tool that can be used to check, repair, analyze and optimize multiple tables from the command line. One of the best features of using mysqlcheck is that you don&#8217;t need to stop the MySQL service to perform the database maintenance.<\/p>\n\n\n\n<p>In this tutorial, we will show you how to check\/repair MySQL databases and tables.<\/p>\n\n\n\n<p><strong>Note<\/strong> : It is recommended to take a backup of your databases before performing a database repair operation.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Basic Syntax of mysqlcheck<\/h2>\n\n\n\n<p>A basic syntax of <a href=\"https:\/\/dev.mysql.com\/doc\/refman\/8.0\/en\/mysqlcheck.html\">mysqlcheck <\/a>is shown below:<\/p>\n\n\n\n<code> mysqlcheck [OPTION] DATABASENAME TABLENAME -u root -p<\/code>\n\n\n\n<p><strong>A brief explanation of each option that you can use with mysqlcheck as shown below:<\/strong> <\/p>\n\n\n\n<p><strong>-c :<\/strong> Used to check a table for errors <\/p>\n\n\n\n<p> <strong>-C :<\/strong> Used to check a tables that are changed after last week. <\/p>\n\n\n\n<p> <strong>-a :<\/strong> Used to analyze tables. <\/p>\n\n\n\n<p> <strong>-A :<\/strong> Used to check all databases. <\/p>\n\n\n\n<p> <strong>-g :<\/strong> Used to check tables for version-dependent changes. <\/p>\n\n\n\n<p> <strong>-B, &#8211;databases :<\/strong> Used to specify multiple databases. <\/p>\n\n\n\n<p> <strong>-F :<\/strong> Used to check tables that are not closed properly. <\/p>\n\n\n\n<p> \u2013<strong>fix-db-names :<\/strong> Used to fix the database name. <\/p>\n\n\n\n<p> \u2013<strong>fix-table-names :<\/strong> Used to fix the table name. <\/p>\n\n\n\n<p> &#8211;<strong>e :<\/strong> Used to perform an extended check. <\/p>\n\n\n\n<p> <strong>-r :<\/strong> Used to repair corrupt table. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Check a Specific Table in a MySQL Database<\/h2>\n\n\n\n<p>In some cases, you need to check a specific table in a specific database. In that case, you can use the following syntax:<\/p>\n\n\n\n<code> mysqlcheck -c databasename tablename -u root -p<\/code>\n\n\n\n<p>For example, checks authors table in books database by running the following command:<\/p>\n\n\n\n<code> mysqlcheck -c books authors -u root -p<\/code>\n\n\n\n<p>You should get the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> books.authors                                      OK<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-1.png\" alt=\"Data integrity check for one database.\" class=\"wp-image-4869\" width=\"734\" height=\"71\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Check All Tables in a MySQL Database <\/h2>\n\n\n\n<p>If you want to check all the tables in a specific database use the following syntax:<\/p>\n\n\n\n<p><code>mysqlcheck -c databasename -u root -p<\/code><\/p>\n\n\n\n<p>For example, check all tables in books database by running the following command:<\/p>\n\n\n\n<p><code> mysqlcheck -c books -u root -p<\/code><\/p>\n\n\n\n<p>You should get the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> Enter password:  \n books.accountant                                   OK\n books.authors                                      OK\n books.writer                                       OK <\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-2.png\" alt=\"Data integrity check for one database and all its tables.\" class=\"wp-image-4870\" width=\"734\" height=\"108\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Check and Optimize All Tables and All MySQL Databases<\/h2>\n\n\n\n<p>You can check all tables and all databases using the following command:<\/p>\n\n\n\n<p><code> mysqlcheck -c  -u root -p --all-databases<\/code><\/p>\n\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> Enter password:  \n books.accountant                                   OK\n books.authors                                      OK\n books.writer                                       OK\n guest.MyGuests                                     OK\n movies.netflix                                     OK\n mysql.columns_priv                                 OK\n mysql.component                                    OK\n mysql.db                                           OK\n mysql.default_roles                                OK\n mysql.engine_cost                                  OK\n mysql.func                                         OK\n mysql.general_log                                  OK\n mysql.global_grants                                OK\n mysql.gtid_executed                                OK\n mysql.help_category                                OK\n mysql.help_keyword                                 OK\n mysql.help_relation                                OK\n mysql.help_topic                                   OK\n mysql.innodb_index_stats                           OK\n mysql.innodb_table_stats                           OK\n mysql.password_history                             OK\n mysql.plugin                                       OK\n mysql.procs_priv                                   OK\n mysql.proxies_priv                                 OK\n mysql.role_edges                                   OK\n mysql.server_cost                                  OK\n mysql.servers                                      OK\n mysql.slave_master_info                            OK\n mysql.slave_relay_log_info                         OK\n mysql.slave_worker_info                            OK<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-3.png\" alt=\"Data integrity check for all databases and all tables.\" class=\"wp-image-4871\" width=\"860\" height=\"536\"\/><\/figure>\n\n\n\n<p>You can optimize all tables and all databases using the following command:<\/p>\n\n\n\n<p><code> mysqlcheck -o root -p --all-databases<\/code><\/p>\n\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> Enter password:  \n books.accountant\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n books.authors\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n books.writer\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n guest.MyGuests\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n movies.netflix\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n mysql.columns_priv\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n mysql.component\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n mysql.db\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n mysql.default_roles\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK\n mysql.engine_cost\n note     : Table does not support optimize, doing recreate + analyze instead\n status   : OK<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-optimize-databases.png\" alt=\"Optimization for all databases and all tables.\" class=\"wp-image-4872\" width=\"860\" height=\"531\"\/><\/figure>\n\n\n\n<p>In the above output, you should see &#8220;Table does not support optimize&#8221; which means the InnoDB table that doesn\u2019t support this option.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Repair MySQL Databases<\/h2>\n\n\n\n<p>To repair accountant tables in books database run the following command:<\/p>\n\n\n\n<p><code> mysqlcheck -r books accountant -u root -p<\/code><\/p>\n\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> mysqlcheck -r books accountant -u root -p\n Enter password:  \n books.accountant                                   OK <\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-repair-1.png\" alt=\"Repair of a table inside a MySQL database.\" class=\"wp-image-4873\" width=\"761\" height=\"73\"\/><\/figure>\n\n\n\n<p>To repair all tables in both books and movies database run the following command:<\/p>\n\n\n\n<p><code> mysqlcheck -r --databases books movies -u root -p<\/code><\/p>\n\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> Enter password:  \n books.accountant                                   OK\n books.authors                                      OK\n books.writer                                       OK\n movies.netflix                                     OK<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-repair-2.png\" alt=\"Repair of all tables inside multiples MySQL database.\" class=\"wp-image-4874\" width=\"740\" height=\"172\"\/><\/figure>\n\n\n\n<p>To check and repair all tables in all databases run the following command:<\/p>\n\n\n\n<p><code> mysqlcheck --auto-repair --all-databases -u root -p<\/code><\/p>\n\n\n\n<p>Output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"> Enter password:  \n books.accountant                                   OK\n books.authors                                      OK\n books.writer                                       OK\n guest.MyGuests                                     OK\n movies.netflix                                     OK\n mysql.columns_priv                                 OK\n mysql.component                                    OK\n mysql.db                                           OK\n mysql.default_roles                                OK\n mysql.engine_cost                                  OK\n mysql.func                                         OK\n mysql.general_log                                  OK\n mysql.global_grants                                OK\n mysql.gtid_executed                                OK\n mysql.help_category                                OK\n mysql.help_keyword                                 OK\n mysql.help_relation                                OK\n mysql.help_topic                                   OK\n mysql.innodb_index_stats                           OK\n mysql.innodb_table_stats                           OK\n mysql.password_history                             OK\n mysql.plugin                                       OK\n mysql.procs_priv                                   OK\n mysql.proxies_priv                                 OK\n mysql.role_edges                                   OK\n mysql.server_cost                                  OK\n mysql.servers                                      OK\n mysql.slave_master_info                            OK\n mysql.slave_relay_log_info                         OK\n mysql.slave_worker_info                            OK\n mysql.slow_log                                     OK\n mysql.tables_priv                                  OK\n mysql.time_zone                                    OK\n mysql.time_zone_leap_second                        OK\n mysql.time_zone_name                               OK\n mysql.time_zone_transition                         OK\n mysql.time_zone_transition_type                    OK<\/pre>\n\n\n\n<br class=\"custom-break\">\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/mysqlcheck-repair-3.png\" alt=\"Mysqlcheck  repair of all databases result.\" class=\"wp-image-4875\" width=\"906\" height=\"536\"\/><\/figure>\n\n\n\n<p><strong>Important note<\/strong>: InnoDB storage engine does not support repair. So you will need to change MySQL storage engine from InnoDB to MyISAM.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Check, Repair and Optimize MySQL Database with PHPMyAdmin<\/h2>\n\n\n\n<p>You can also check, repair and optimize tables and databases using the PHPMyAdmin web interface.<\/p>\n\n\n\n<p><strong>You can follow the below steps to check, repair and optimize tables and databases:<\/strong><\/p>\n\n\n\n<p><strong>1- <\/strong>Open the phpMyAdmin tool through a web browser as shown below:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-1.png\" alt=\"Select a database into PHPMyAdmin.\" class=\"wp-image-4876\" width=\"975\" height=\"414\"\/><\/figure>\n\n\n\n<p><strong>2-<\/strong>  Select the affected database in the left pane. You should see all the tables in the right pane in the following screen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-2.png\" alt=\"Select a tables into PHPMyAdmin.\" class=\"wp-image-4877\" width=\"975\" height=\"440\"\/><\/figure>\n\n\n\n<p><strong>3-<\/strong>  Click <strong>Check All<\/strong> to select all the tables. At the bottom of the window, choose <strong>Check<\/strong> <strong>Table<\/strong> from the menu. You should see a summary of the tables in the following screen:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-3.png\" alt=\"Run a Check Tables on selected tables into PHPMyAdmin.\" class=\"wp-image-4878\" width=\"857\" height=\"440\"\/><\/figure>\n\n\n\n<p><strong>4-<\/strong>  To repair the table, <strong>Check<\/strong> <strong>All<\/strong> to select all the tables and choose <strong>Repair<\/strong> <strong>Table<\/strong> from the menu. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-4.png\" alt=\"Run a Repair tables on selected tables into PHPMyAdmin.\" class=\"wp-image-4879\" width=\"857\" height=\"446\"\/><\/figure>\n\n\n\n<p>Then you should get a confirmation that the command been executed successfully:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-5.png\" alt=\"Repair tables command confirmation.\" class=\"wp-image-4880\" width=\"956\" height=\"503\"\/><\/figure>\n\n\n\n<p><strong>5-<\/strong> To optimize the table, <strong>Check<\/strong> <strong>All<\/strong> to select all the tables and choose <strong>Optimize<\/strong> <strong>Table<\/strong> from the menu. You should see the following page:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-6.png\" alt=\"Run a Optimize tables on all selected tables into PHPMyAdmin.\" class=\"wp-image-4881\" width=\"856\" height=\"443\"\/><\/figure>\n\n\n\n<p>Then you should get a confirmation that the command been executed successfully:<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized is-style-default\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/PhpMyAdmin-7.png\" alt=\"Optimize tables command confirmation.\" class=\"wp-image-4882\" width=\"964\" height=\"504\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In the above tutorial, we learned how to check and repair MySQL table using mysqlcheck command-line tool. We also learned how to check, repair and optimize database tables using the PHPMyAdmin web interface. I hope you can now easily fix your corrupted tables using this tool.<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases.<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":3,"featured_media":4868,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[61],"tags":[161,163,24,120,164],"class_list":["post-4867","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","tag-database","tag-db","tag-mysql","tag-optimize","tag-repair"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.0 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to check and repair MySQL Databases - Globo.Tech<\/title>\n<meta name=\"description\" content=\"The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases\" \/>\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.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to check and repair MySQL Databases - Globo.Tech\" \/>\n<meta property=\"og:description\" content=\"The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"Globo.Tech\" \/>\n<meta property=\"article:published_time\" content=\"2020-03-12T19:56:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-03-12T19:59:47+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"GloboTech Communications\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"GloboTech Communications\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/\",\"name\":\"How to check and repair MySQL Databases - Globo.Tech\",\"isPartOf\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg\",\"datePublished\":\"2020-03-12T19:56:07+00:00\",\"dateModified\":\"2020-03-12T19:59:47+00:00\",\"author\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\"},\"description\":\"The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases\",\"breadcrumb\":{\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#primaryimage\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg\",\"contentUrl\":\"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg\",\"width\":1200,\"height\":628,\"caption\":\"How to check and repair MySQL Databases\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.globo.tech\/learning-center\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to check and repair MySQL Databases\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#website\",\"url\":\"https:\/\/www.globo.tech\/learning-center\/\",\"name\":\"Globo.Tech\",\"description\":\"Welcome to the Official Globo.Tech Learning Center\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87\",\"name\":\"GloboTech Communications\",\"sameAs\":[\"http:\/\/www.gtcomm.net\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to check and repair MySQL Databases - Globo.Tech","description":"The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases","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.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/","og_locale":"en_US","og_type":"article","og_title":"How to check and repair MySQL Databases - Globo.Tech","og_description":"The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases","og_url":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/","og_site_name":"Globo.Tech","article_published_time":"2020-03-12T19:56:07+00:00","article_modified_time":"2020-03-12T19:59:47+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg","type":"image\/jpeg"}],"author":"GloboTech Communications","twitter_misc":{"Written by":"GloboTech Communications","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/","url":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/","name":"How to check and repair MySQL Databases - Globo.Tech","isPartOf":{"@id":"https:\/\/www.globo.tech\/learning-center\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#primaryimage"},"image":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg","datePublished":"2020-03-12T19:56:07+00:00","dateModified":"2020-03-12T19:59:47+00:00","author":{"@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87"},"description":"The mysqlcheck client performs table maintenance: It checks, repairs, optimizes, or analyzes tables. Learn how to check and repair MySQL databases","breadcrumb":{"@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#primaryimage","url":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg","contentUrl":"https:\/\/www.globo.tech\/learning-center\/wp-content\/uploads\/2020\/03\/HowToCheckAndRepairMySQL.jpg","width":1200,"height":628,"caption":"How to check and repair MySQL Databases"},{"@type":"BreadcrumbList","@id":"https:\/\/www.globo.tech\/learning-center\/how-to-check-and-repair-mysql-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.globo.tech\/learning-center\/"},{"@type":"ListItem","position":2,"name":"How to check and repair MySQL Databases"}]},{"@type":"WebSite","@id":"https:\/\/www.globo.tech\/learning-center\/#website","url":"https:\/\/www.globo.tech\/learning-center\/","name":"Globo.Tech","description":"Welcome to the Official Globo.Tech Learning Center","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.globo.tech\/learning-center\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.globo.tech\/learning-center\/#\/schema\/person\/e17784b37f4a4f49b7bc611847912e87","name":"GloboTech Communications","sameAs":["http:\/\/www.gtcomm.net"]}]}},"_links":{"self":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4867","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/comments?post=4867"}],"version-history":[{"count":9,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4867\/revisions"}],"predecessor-version":[{"id":4891,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/posts\/4867\/revisions\/4891"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media\/4868"}],"wp:attachment":[{"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/media?parent=4867"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/categories?post=4867"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.globo.tech\/learning-center\/wp-json\/wp\/v2\/tags?post=4867"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}