{"id":246,"date":"2013-09-23T12:40:40","date_gmt":"2013-09-23T10:40:40","guid":{"rendered":"http:\/\/evcz.tk\/blog\/?p=246"},"modified":"2013-09-23T12:41:02","modified_gmt":"2013-09-23T10:41:02","slug":"convert-prestashop-tables-from-mysisam-to-innodb-using-phpmyadmin-2","status":"publish","type":"post","link":"https:\/\/evcz.tk\/blog\/2013\/09\/23\/convert-prestashop-tables-from-mysisam-to-innodb-using-phpmyadmin-2\/","title":{"rendered":"Convert Prestashop tables from mysisam to innodb using phpmyadmin"},"content":{"rendered":"<p>First run this query replacing databasetoconvert with the database name you want to convert<\/p>\n<pre lang=\"mysql\">\r\nSELECT CONCAT('ALTER TABLE ', table_name, ' ENGINE=InnoDB;') AS sql_statements \r\nFROM information_schema.tables AS tb \r\nWHERE table_schema = 'databasetoconvert' \r\nAND `ENGINE` = 'MyISAM' \r\nAND `TABLE_TYPE` = 'BASE TABLE' \r\nORDER BY table_name DESC LIMIT 0, 10000 ;\r\n<\/pre>\n<p>then copy the output and run it again against the database you want to convert<\/p>\n","protected":false},"excerpt":{"rendered":"<p>First run this query replacing databasetoconvert with the database name you want to convert SELECT CONCAT(&#8216;ALTER TABLE &#8216;, table_name, &#8216; ENGINE=InnoDB;&#8217;) AS sql_statements FROM information_schema.tables AS tb WHERE table_schema = &#8216;databasetoconvert&#8217; AND `ENGINE` = &#8216;MyISAM&#8217; AND `TABLE_TYPE` = &#8216;BASE TABLE&#8217; ORDER BY table_name DESC LIMIT 0, 10000 ; then copy the output and run it &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/evcz.tk\/blog\/2013\/09\/23\/convert-prestashop-tables-from-mysisam-to-innodb-using-phpmyadmin-2\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Convert Prestashop tables from mysisam to innodb using phpmyadmin&#8221;<\/span><\/a><\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3,20],"tags":[],"class_list":["post-246","post","type-post","status-publish","format-standard","hentry","category-howto","category-snippets"],"_links":{"self":[{"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/posts\/246","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/comments?post=246"}],"version-history":[{"count":1,"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/posts\/246\/revisions"}],"predecessor-version":[{"id":249,"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/posts\/246\/revisions\/249"}],"wp:attachment":[{"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/media?parent=246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/categories?post=246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/evcz.tk\/blog\/wp-json\/wp\/v2\/tags?post=246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}