How can i convert all my Db's FROM ISAM to MyISAM ?

[furquan]

Hello all,

My users are now demanding MySQL 5.5 and i am currently running 5.0, Can any one here guide, me, How can i convert all my db's to MyISAM before using the WHM upgrade option to 5.5 ?

Any "How-To's" on doing this ?

Thank you

 

[furquan]

Basically I just have ONE Db' that shows i am using ISM engine.

I used this command to find out :-

find /var/lib/mysql -name '*.ISM'

since it has many tables in it, altering tables one by one, is going to be a tedious task,

Is there any way i can have this whole db converted to MyISAM engine ?

Thank you

 

[Infopro]

The latest PHP available in cPanel's Easy Apache is: 5.4.11, not sure I'd want to upgrade past that, manually.