Re: InnoDB to MyISAM

[Rafal Kedziorski]

hi,

At 14:54 25.05.2005, Scott Purcell wrote:
>Hello,
>I posted last night but did not receive an answer. I am trying to create a 
>fulltext index, but my table was created as an InnoDB type.
>
>There is quite a bit of data there (1000+ records) and I need to change to 
>a MyISAM table for the indexing for fulltext search.
>
>How can I convert the InnoDB to a MyISAM, and also, when using MyISAM, can 
>I have foreign

http://dev.mysql.com/doc/mysql/en/converting-tables-to-innodb.html

>key relationships?

MyISAM can't FK's.


Regards,
Rafal



>Thanks,
>Scott
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:    http://lists.mysql.com/mysql?unsub=1