1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

How to convert InnoDB table to MyISAM

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

  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