New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
MySQL command help
pbalazs123
Member
Hello,
I don't have big experience in administering MySQL so i need some help.
I have a database with a lot of tables and i would like to change all the tables which runs on InnoDB engine to MyISAM with an SQL command. But only the InnoDB ones selectively because i have tables with MEMORY aswell and i don't want to alter those tables.
Can someone write down this for me?
And please don't copy/paste it from google because those scripts won't run like i need.
Keyword: selectively
Thanks a lot!
Comments
see the second answer. works 100%
http://stackoverflow.com/questions/3856435/how-to-convert-all-tables-from-myisam-into-innodb
Why are you unhappy with InnoDB? Give MariaDB + Aria a try!
@ironhide Thx, but done it already in an other way
Exported the whole database, changed all the InnoDB words to MyISAM and re-imported. 
@agentsmith
For the typical website scenario, usually MyISAM offers better performance at a lower server cost. Btw i have tried MariaDB and it's cool. I will migrate to it later.