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

furquan

Well-Known Member
Jul 27, 2002
473
4
168
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

Well-Known Member
Jul 27, 2002
473
4
168
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