Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am migrating a database with MyISAM tables to an InnoDB engine.

Some of the tables in MyISAM have full text indexes. If I have to retain the full text indexes in InnoDB engine, what are the things that I need to do?

I've read that versions of MySQL before 5.6 do not support full text indexing natively in InnoDB. I am using MySQL 5.5 in Amazon RDS.

share|improve this question

1 Answer 1

You can't do it. If you need full text indexes, and you're on MySQL 5.5 or earlier, then you can't use the InnoDB storage engine. Either upgrade to 5.6.4 or later, index your text in some other way, or leave those tables as MyISAM.

share|improve this answer
    
can I use sphinx for full test indexing along with InnoDB Engine in MySQL 5.5 ?? The Problem is I am on Amazon RDS and I will not be able to install anything. If I am running on a EC2 instance, will I be able to use sphinx for full test indexing along with InnoDB Engine in MySQL 5.5 ? –  Santhosh S May 1 '12 at 13:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.