{"id":1325,"date":"2013-02-27T23:00:19","date_gmt":"2013-02-27T22:00:19","guid":{"rendered":"https:\/\/www.herewithme.fr\/?p=1325"},"modified":"2013-02-27T23:01:00","modified_gmt":"2013-02-27T22:01:00","slug":"convertir-toutes-ses-tables-en-innodb-ou-myisam","status":"publish","type":"post","link":"https:\/\/www.herewithme.fr\/2013\/02\/27\/convertir-toutes-ses-tables-en-innodb-ou-myisam\/","title":{"rendered":"Convertir toutes ses tables en InnoDB ou MyISAM"},"content":{"rendered":"<p><a title=\"Convertir toutes ses tables en InnoDB ou MyISAM\" href=\"https:\/\/kvz.io\/blog\/2010\/04\/27\/convert-all-tables-to-innodb-in-one-go\/\">Convertir toutes ses tables en InnoDB ou MyISAM<\/a><\/p>\n<p>Ce qui donne pour tout passer en MyISAM et \u00e9conomiser de la RAM :<\/p>\n<pre class=\"brush: sql\">SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=MyISAM;')\r\nFROM information_schema.tables\r\nWHERE 1=1\r\n    AND engine = 'InnoDB' \r\n    AND table_schema NOT IN ('information_schema', 'mysql', 'performance_schema');<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Convertir toutes ses tables en InnoDB ou MyISAM Ce qui donne pour tout passer en MyISAM et \u00e9conomiser de la RAM : SELECT CONCAT(&lsquo;ALTER TABLE &lsquo;,table_schema,&rsquo;.&rsquo;,table_name,&rsquo; ENGINE=MyISAM;&rsquo;) FROM information_schema.tables WHERE 1=1 AND engine = &lsquo;InnoDB&rsquo; AND table_schema NOT IN (&lsquo;information_schema&rsquo;, &lsquo;mysql&rsquo;, &lsquo;performance_schema&rsquo;);<\/p>\n","protected":false},"author":12,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"link","meta":{"footnotes":""},"categories":[126],"tags":[160,175],"_links":{"self":[{"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/posts\/1325"}],"collection":[{"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/comments?post=1325"}],"version-history":[{"count":0,"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/posts\/1325\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/media?parent=1325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/categories?post=1325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.herewithme.fr\/wp-json\/wp\/v2\/tags?post=1325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}