{"id":189,"date":"2018-08-19T23:09:01","date_gmt":"2018-08-20T02:09:01","guid":{"rendered":"http:\/\/www.bfnetworks.com.br\/?p=189"},"modified":"2022-07-15T10:18:35","modified_gmt":"2022-07-15T13:18:35","slug":"diminuindo-tamanho-do-arquivo-ibdata1-mysql","status":"publish","type":"post","link":"https:\/\/bfnetworks.com.br\/diminuindo-tamanho-do-arquivo-ibdata1-mysql\/","title":{"rendered":"DIMINUINDO TAMANHO DO ARQUIVO IBDATA1 &#8211; MYSQL"},"content":{"rendered":"<p>Realizando backup do banco de dados<br \/>\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">mysqldump&nbsp;-u&#8221;usuario&#8221;&nbsp;-p&#8221;senha&#8221;&nbsp;bancodedados&nbsp;&gt;&nbsp;bancodedados-bkp.sql<\/div>   <\/div><br \/>\nRemove o banco de dados propriamente dito no console do MySQL:<\/p>\n<pre>DROP DATABASE bancodedados;<\/pre>\n<p>Pare o servi\u00e7o do MySQL:<br \/>\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"line\" data-delay=\"10\" data-speed=\"100\">Debian#&nbsp;\/etc\/init.d\/mysqld&nbsp;stop<\/div><div class=\"line\" data-delay=\"10000\" data-speed=\"100\">Centos7#&nbsp;systemctl&nbsp;stop&nbsp;mysqld<\/div>   <\/div><br \/>\nRemova o arquivo ibdata1<br \/>\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">rm&nbsp;-rf&nbsp;\/var\/lib\/mysql\/ibdata1<\/div>   <\/div><br \/>\nInsira as linhas abaixo no arquivo \/etc\/my.cnf<\/p>\n<pre>innodb_buffer_pool_size = 1028M\ninnodb_file_per_table=1<\/pre>\n<p>Inicie o servi\u00e7o mysqld<br \/>\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"line\" data-delay=\"10\" data-speed=\"100\">Debian#&nbsp;\/etc\/init.d\/mysqld&nbsp;start<\/div><div class=\"line\" data-delay=\"10000\" data-speed=\"100\">Centos7#&nbsp;systemctl&nbsp;start&nbsp;mysqld<\/div>   <\/div><br \/>\nRecria o banco de dados no console do MySQL<\/p>\n<pre>CREATE DATABASE bancodedados;<\/pre>\n<p>Restaura o backup dos banco de dados removido:<br \/>\n<div class=\"showyourterms dark noanimate nostatusbar\">\n<div class=\"command\" data-action=\"command\" data-delay=\"10000\" data-speed=\"100\">mysql&nbsp;-uroot&nbsp;-p&nbsp;bancodedados&nbsp;&lt;&nbsp;bancodedados.sql<\/div>   <\/div><\/p>\n<h3>FONTE:<\/h3>\n<p>http:\/\/wiki.adilson.net.br\/linux\/banco-de-dados\/mysql\/tamanho-do-ibdata1<br \/>\nhttp:\/\/lrodrigo.sgs.lncc.br\/wp\/d19icas\/reciclando-o-espaco-utilizado-pelo-arquivo-ibdata1-do-mysql\/<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Realizando backup do banco de dados Remove o banco de dados propriamente dito no console do MySQL: DROP DATABASE bancodedados; Pare o servi\u00e7o do MySQL: Remova o arquivo ibdata1 Insira as linhas abaixo no arquivo \/etc\/my.cnf innodb_buffer_pool_size = 1028M innodb_file_per_table=1 Inicie o servi\u00e7o mysqld Recria o banco de dados no console do MySQL CREATE DATABASE [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[5],"tags":[42,46,110],"_links":{"self":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/189"}],"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=189"}],"version-history":[{"count":1,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/189\/revisions"}],"predecessor-version":[{"id":1901,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/posts\/189\/revisions\/1901"}],"wp:attachment":[{"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/media?parent=189"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/categories?post=189"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bfnetworks.com.br\/wp-json\/wp\/v2\/tags?post=189"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}