{"id":352,"date":"2018-10-03T13:24:16","date_gmt":"2018-10-03T16:24:16","guid":{"rendered":"http:\/\/www.bfnetworks.com.br\/?p=352"},"modified":"2022-07-15T10:18:34","modified_gmt":"2022-07-15T13:18:34","slug":"comando-mysqlcheck-verificando-e-corrigindo-db-mysql","status":"publish","type":"post","link":"https:\/\/bfnetworks.com.br\/comando-mysqlcheck-verificando-e-corrigindo-db-mysql\/","title":{"rendered":"COMANDO MYSQLCHECK: VERIFICANDO E CORRIGINDO DB MYSQL"},"content":{"rendered":"<p>Com o comando mysqlcheck podemos verificar se um determinado banco ou tabela de um banco est\u00e1 integro, sem erros ou corrompido. Mostrarei algumas de suas op\u00e7\u00f5es das diversas que existem.<\/p>\n<ul>\n<li>\n<h3>Verificando uma determinada tabela<\/h3>\n<\/li>\n<\/ul>\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">mysqlcheck&nbsp;-c&nbsp;nome_do_banco&nbsp;nome_da_tabela&nbsp;-u&nbsp;root&nbsp;-p<\/div>   <\/div>\n<ul>\n<li>\n<h3>Verificando um banco inteiro<\/h3>\n<\/li>\n<\/ul>\n<p><div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">mysqlcheck&nbsp;-c&nbsp;nome_do_banco&nbsp;-u&nbsp;root&nbsp;-p<\/div>   <\/div><br \/>\nEm testes que precisei no banco de um zabbix server, tive o seguinte resultado abaixo, mostrando que &#8220;algo de errado n\u00e3o estava certo&#8221;, ou seja, com erros.<\/p>\n<pre>zabbixdb.group_prototype                           OK\nzabbixdb.groups                                    OK\n<b>zabbixdb.history\nwarning  : Table is marked as crashed\nwarning  : 1 client is using or hasn't closed the table properly\nerror    : record delete-link-chain corrupted\nerror    : Corrupt<\/b>\nzabbixdb.history_log                               OK\nzabbixdb.history_text                              OK\n<b>zabbixdb.history_uint\nwarning  : Table is marked as crashed\nwarning  : 1 client is using or hasn't closed the table properly\nerror    : record delete-link-chain corrupted\nerror    : Corrupt<\/b>\nzabbixdb.host_discovery                            OK\nzabbixdb.host_inventory                            OK\n<\/pre>\n<ul>\n<li>\n<h3>Corrigindo erros de um banco<\/h3>\n<\/li>\n<\/ul>\n<p><div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">mysqlcheck&nbsp;-r&nbsp;nome_do_banco&nbsp;-u&nbsp;root&nbsp;-p<\/div>   <\/div><br \/>\nObtive o seguinte resultado, corrigindo assim os erros que tive no banco:<\/p>\n<pre>zabbixdb.group_prototype                           OK\nzabbixdb.groups                                    OK\n<b>zabbixdb.history\nwarning  : Number of rows changed from 5764036 to 5763139\nstatus   : OK<\/b>\nzabbixdb.history_log                               OK\nzabbixdb.history_text                              OK\n<b>zabbixdb.history_uint\nwarning  : Number of rows changed from 13583760 to 13633846\nstatus   : OK<\/b>\nzabbixdb.host_discovery                            OK\nzabbixdb.host_inventory                            OK\n<\/pre>\n<h3>FONTES<\/h3>\n<blockquote class=\"wp-embedded-content\" data-secret=\"hc77BtJpC9\"><p><a href=\"https:\/\/elias.praciano.com\/2014\/03\/mysql-use-o-mysqlcheck-para-fazer-manutencao-das-suas-tabelas\/\">MySQL: use o mysqlcheck para fazer manuten\u00e7\u00e3o das suas tabelas<\/a><\/p><\/blockquote>\n<p><iframe title=\"&#8220;MySQL: use o mysqlcheck para fazer manuten\u00e7\u00e3o das suas tabelas&#8221; &#8212; Elias Praciano\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" src=\"https:\/\/elias.praciano.com\/2014\/03\/mysql-use-o-mysqlcheck-para-fazer-manutencao-das-suas-tabelas\/embed\/#?secret=hc77BtJpC9\" data-secret=\"hc77BtJpC9\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Como o comando mysqlcheck podemos verificar se um determinado banco ou tabela de um banco est\u00e1 integro, sem erros ou corrompido. Mostrarei algumas de suas op\u00e7\u00f5es, das diversas que existem.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[46,47,110],"_links":{"self":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/352"}],"collection":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/comments?post=352"}],"version-history":[{"count":1,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/352\/revisions"}],"predecessor-version":[{"id":1894,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/352\/revisions\/1894"}],"wp:attachment":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/media?parent=352"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/categories?post=352"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/tags?post=352"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}