Convert tables from InnoDB to MyISAM

Connect with other users about what to run on your webhosting (and how to run it) here.
Post Reply
Bubka3
Compulsive poster
Compulsive poster
Posts: 70
https://www.youtube.com/channel/UC40BgXanDqOYoVCYFDSTfHA
Joined: Fri Feb 21, 2014 10:24 am

Convert tables from InnoDB to MyISAM

Post by Bubka3 »

Does anyone have any suggestions for converting a bunch of InnoDB tables to MyISAM? I can of course do each one by hand, but I have 177 tables so that might take a while.
Top
User avatar
Spray
Former staff
Former staff
Posts: 630
Joined: Wed Dec 28, 2011 10:41 pm
Location: Oregon

Re: Convert tables from InnoDB to MyISAM

Post by Spray »

You could always get a complete dump of the database, then replace all InnoDB references with MyISAM, then re-import the dump file. If any of your tables are using foreign keys or if you have software that relies on transactions in InnoDB, you will need to leave these tables be, as MyISAM does not support these features.
Top
Post Reply

Return to “Webhosting”