Fluoresce Posted November 17, 2014 Share Posted November 17, 2014 I use PHPMyAdmin. I have to convert an InnoDB table to a MyISAM table. I then have to add a FULLTEXT index to two of the table's columns. Is this how I should proceed? 1) Backup table by exporting its contents. 2) Go to "Relation view" and drop foreign key constraints. 3) ALTER TABLE `table_name` ENGINE = MyISAM; 4) ALTER TABLE `table_name` ADD FULLTEXT index_name (col1,col2); Is that it? Is it safe? Note that the table contains approximately 3,500 rows. Quote Link to comment https://forums.phpfreaks.com/topic/292523-how-to-convert-table-from-innodb-to-myisam/ Share on other sites More sharing options...
QuickOldCar Posted November 17, 2014 Share Posted November 17, 2014 That's fine, you can also select the table, click operations and change the storage engine to myisam. Quote Link to comment https://forums.phpfreaks.com/topic/292523-how-to-convert-table-from-innodb-to-myisam/#findComment-1496839 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.