Altering the table from innodb to mysiam may cause some performance issues depending on how the application is developed. What version of mysql are you running? It may be worth upgrading if you have not yet.
If you want to change the default method you can add skip--innodb option in the my.cnf file.
If you do not alter table to myisam and add skip-innodb into mysql and restart it, the mysql will fail to read the table structure as the innodb table is not loaded into the mysql. This will cause issue to the existing databases. You can see following sort of error when you try to describe the table. This happens because the table related files used by the both are different. Mysql will fail to recognize innodb tables.
ERROR 1033 (HY000): Incorrect information in file: './dbname/table_name.frm'
thanks for the code and suggestions,
yes I intend to take backups for which ever file I intend to edit, as I am aware of the consequences if it goes wrong - prevention better than cure
steven - I have asked the developers on this, and I am awaiting response from this, so can't comment till they respond.
you guys have mentioned to edit in mysql prompt, is it under phpmyadmin,??
As I haven't taken tht closer look earlier or is it in a ssh mode only...