How to convert InnoDB table to MyISAM

Discussion in 'Databases' started by Masterful, Nov 17, 2014.

0
  1. #1
    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 do it?
    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 there anything else that I should do?

    Will any of my site's PHP need changing?
     
    Masterful, Nov 17, 2014 IP