I don't know if anybody is still interested in this, but here is what I did:
*Using phpMyAdmin and Gedit on Ubuntu Linux. You will need a text editor that allows you to select the line change between the text lines or use a line change operator (usually \n)
1) Select the DB you want to operate;
2) Click on the "SQL" tab;
3) execute this query:
4) Copy the result to a text editor (I've used Gedit - you will need good "Search and Replace funcionality);
5) Erase the following lines (In my case the table prefixes are mxlb_. Find what is yours):
6) Use the "Search and Replace" to replace (remember to use your prefix, this one is mine)
ALTER TABLE mxlb_
7) Use the "Search and Replace" again, selecting from the end of the first line to the begining of the next line and choose "Search and Replace" from you text editor (this is tricky, not all text editors do this. What you want is the line change. Again, this works on Gedit);
8) Replace the line change code by
ENGINE = INNODB;\n
Note that there's an empty space before ENGINE. You need it!
ENGINE = INNODB
after the last table name on the last line (there wasn't a line change after it...)
10) Copy all this, go to the SQL tab of your DB on phpMyAdmin and paste it on the box, then click "Execute".
There you are!
Designer, Ergonomist, MSc Production Engineeringhttp://www.softdesign.eti.br