{"id":670,"date":"2012-05-15T04:31:13","date_gmt":"2012-05-15T02:31:13","guid":{"rendered":"http:\/\/www.shukko.com\/x3\/?p=670"},"modified":"2024-09-30T22:24:05","modified_gmt":"2024-09-30T20:24:05","slug":"mysql-optimize-and-repair-all-db","status":"publish","type":"post","link":"https:\/\/www.shukko.com\/x3\/2012\/05\/15\/mysql-optimize-and-repair-all-db\/","title":{"rendered":"MySQL Repair and Optimize All DB"},"content":{"rendered":"<p><code><br \/>\nmysqlcheck -u da_admin -p --auto-repair --optimize --all-databases<\/p>\n<p>veya<\/p>\n<p>mysqlcheck -Aor -u root -p<br \/>\nA = all databases<br \/>\no = optimize<br \/>\nr = repair<br \/>\n<\/code><\/p>\n\n\n<pre class=\"wp-block-code\"><code>bun daha kolay yonetmi varmis 2024 30 eylulde ogrendim\n\n\/usr\/bin\/mysqlcheck -uda_admin -p`grep \"^passwd=\" \/usr\/local\/directadmin\/conf\/mysql.conf | cut -d= -f2` --skip-write-binlog --optimize --all-in-1 --all-databases<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysqlcheck -u da_admin -p &#8211;auto-repair &#8211;optimize &#8211;all-databases veya mysqlcheck -Aor -u root -p A = all databases o = optimize r = repair<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-670","post","type-post","status-publish","format-standard","hentry","category-kategerisiz"],"_links":{"self":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/670","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/comments?post=670"}],"version-history":[{"count":4,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/670\/revisions"}],"predecessor-version":[{"id":1597,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/posts\/670\/revisions\/1597"}],"wp:attachment":[{"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/media?parent=670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/categories?post=670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.shukko.com\/x3\/wp-json\/wp\/v2\/tags?post=670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}