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.
Converting existing MySQL installation/db's from InnoDB to MyISAM?
Long story made short: Started out with a bone stock install of MySQL, didn't bother to tweak as it worked fine out of the box. Restored db's and went on with life. Looking at it these days though I am aiming to do a small bit of tweaking wherever possible and get memory usage trimmed (although I may very well end up switching off CentOS and back to old reliable Debian before it gets too involved to do a backup and restore).
Biggest thing I haven't been able to find a solid answer for is switching MySQL and its existing db's over to MyISAM from InnoDB. Never been able to really find a working step-by-step solution.
Comments
That's a long story short: How convert InnoDB 2 MyISAM?
The tables should be the same, regardless of the engine used.
You could attempt (be sure to make backups, i'm not responsible for your destroyed data, etc) to update the ENGINE= part of the table definition:
SELECT CONCAT('ALTER TABLE ',table_schema,'.',table_name,' engine=MyISAM;') FROM information_schema.tables WHERE engine = 'InnoDB';
(edit) Some cursory google searching tells me that altering tables to select the new engine is the most popular method.
http://www.kavoir.com/2009/09/mysql-how-to-change-or-convert-myisam-to-innodb-or-vice-versa.html
http://forums.mysql.com/read.php?21,26193,49429#msg-49429
http://technotes.twosmallcoins.com/?p=356
http://stackoverflow.com/questions/4692895/convert-innodb-to-myisam-with-innodb-disabled
(/edit)
Not everyone here just posts a one-line question and expects people to do all the work for them.
how about mysqldump ; drop table ; create table ; source the_dump
Well, 1) I do 2) It would be easier and faster to read.
This. Enjoy
While not a step by step guide, I touched on this for my blog article for vBulletin 4.x customers switching between MyISAM and InnoDB and vice versa including covering why one would want to stick with either storage engine http://vbtechsupport.com/675/
HTH
Just alter table x engine = myisam. Simple as that, unless I'm missing something?
It can also work with phpmyadmin, or export the statements, there was also a script somewhere which does all the stuff.
M
Sorry for the late reply. Full time work 3rd shift is hell. I did finally end up going with @rds100 's suggestion and came out fine. Appreciate all the suggestions.