Jump to content

How to convert table from InnoDB to MyISAM


Fluoresce

Recommended Posts

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.