I inherited a DB using myisam on mysql 5.1 because of the need for fulltext search. I now read that fulltext search is available on mysql 5.6 innodb. Doing this would solve a lot of problems, as long as it works.
I'm abou to try it on an experimental db, but here's a puzzle: I have a mysqldump from the production database, which naturally wants to recreate the tables as myisam.
Several options present themselves:
- edit the dump file -- which is an 8 GiB file so editing might be a tad difficult.
- just load the dump and convert the engine afterward -- but sourcing in the file seems to take a long time.
- Find some magic that will force the new DB engine to be innodb no matter what the dump says.
Is there another option? Which option should I choose?
I'll cheerfully admit DBA is not my primary skill.