{"id":900,"date":"2015-06-04T09:39:19","date_gmt":"2015-06-04T07:39:19","guid":{"rendered":"http:\/\/fougere.myds.me:8080\/info\/?p=900"},"modified":"2015-06-04T09:39:19","modified_gmt":"2015-06-04T07:39:19","slug":"my_alter_engine_mig-sh","status":"publish","type":"post","link":"http:\/\/les-fougs.com\/wordpress\/2015\/06\/04\/my_alter_engine_mig-sh\/","title":{"rendered":"my_alter_engine_mig.sh"},"content":{"rendered":"<pre>#!\/bin\/bash\nfile=\/exploit\/scripts\/my_alter_table_engine_mig.sql\nfile2=\/exploit\/scripts\/my_alter_table_engine_mig_spe.sql\nmysql -pzsxedc --batch --skip-column-names --execute=\"select concat('ALTER TABLE ',table_schema,'.',table_name,' ENGINE=InnoDB;') from information_schema.TABLES where table_schema not in ('information_schema', 'mysql', 'performance_schema') and table_type &lt;&gt; 'VIEW' and engine &lt;&gt; 'InnoDB' and table_name not in ('General Ledger','Controlling#temporary','Overdue-DrillThrough')\" &gt; $file\ncat $file\ntime mysql -pzsxedc &lt;$file\ncat $file2\ntime mysql -pzsxedc &lt;$file2<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>#!\/bin\/bash file=\/exploit\/scripts\/my_alter_table_engine_mig.sql file2=\/exploit\/scripts\/my_alter_table_engine_mig_spe.sql mysql -pzsxedc &#8211;batch &#8211;skip-column-names &#8211;execute=&nbsp;&raquo;select concat(&lsquo;ALTER TABLE &lsquo;,table_schema,&rsquo;.&rsquo;,table_name,&rsquo; ENGINE=InnoDB;&rsquo;) from information_schema.TABLES where table_schema not in (&lsquo;information_schema&rsquo;, &lsquo;mysql&rsquo;, &lsquo;performance_schema&rsquo;) and table_type &lt;&gt; &lsquo;VIEW&rsquo; and engine &lt;&gt; &lsquo;InnoDB&rsquo; and table_name not in (&lsquo;General Ledger&rsquo;,&rsquo;Controlling#temporary&rsquo;,&rsquo;Overdue-DrillThrough&rsquo;)&nbsp;&raquo; &gt; $file cat $file time mysql -pzsxedc &lt;$file cat $file2 time mysql -pzsxedc &lt;$file2<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[53,35],"tags":[],"_links":{"self":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/900"}],"collection":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/comments?post=900"}],"version-history":[{"count":0,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/posts\/900\/revisions"}],"wp:attachment":[{"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/media?parent=900"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/categories?post=900"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/les-fougs.com\/wordpress\/wp-json\/wp\/v2\/tags?post=900"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}