{"id":221,"date":"2013-02-06T02:34:32","date_gmt":"2013-02-06T02:34:32","guid":{"rendered":"http:\/\/blog.law.gmu.edu\/webservices\/?p=221"},"modified":"2013-02-06T02:34:32","modified_gmt":"2013-02-06T02:34:32","slug":"mysql-repair-optimize-all-tables-in-all-databases","status":"publish","type":"post","link":"https:\/\/sls.gmu.edu\/web\/2013\/02\/06\/mysql-repair-optimize-all-tables-in-all-databases\/","title":{"rendered":"MySQL: Repair &amp; Optimize all Tables in all Databases"},"content":{"rendered":"<p><code>mysqlcheck -u root -p --auto-repair --check --optimize --all-databases<\/code><br \/>\nor<br \/>\n<code>mysqlcheck -Aor -u root -p<\/code><br \/>\nA = all databases<br \/>\no = optimize<br \/>\nr = repair<\/p>\n<p>via <a href=\"https:\/\/www.bytemods.com\/howto\/173\/mysql-repair-en-optimize-all-tables-in-all-databases\">Byte Mods<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysqlcheck -u root -p &#8211;auto-repair &#8211;check &#8211;optimize &#8211;all-databases or mysqlcheck -Aor -u root -p A = all databases o = optimize r = repair via Byte Mods<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[5],"tags":[23],"class_list":["post-221","post","type-post","status-publish","format-standard","hentry","category-command-lines","tag-mysql"],"_links":{"self":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/posts\/221","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/comments?post=221"}],"version-history":[{"count":0,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/posts\/221\/revisions"}],"wp:attachment":[{"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/media?parent=221"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/categories?post=221"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sls.gmu.edu\/web\/wp-json\/wp\/v2\/tags?post=221"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}