Hi,
I am in a bit of a sticky situation with this MySQL database. I need to add full text indexing to a couple tables for some relevance searching but the database is all INNODB. If I convert these 2 tables to MyISAM I guess that solves the full text indexing problem but I don't know enough about "foreign keys". Apparently that's only in INNODB so if I change 2 tables to MyISAM will that mess anything up? Any advice would be greatly appreciated. Thanks!
Yes; if you convert the table to MyISAM it would break all the foreign key relationships; it would also break any transactions as well. Most DBMSs don't have this problem.
Weedpacket;10898361 wrote:Yes; if you convert the table to MyISAM it would break all the foreign key relationships; it would also break any transactions as well. Most DBMSs don't have this problem.
Would it actually break anything?
Uh, yeah; assuming you manage to do it at all without weird error messages, it would break foreign key relationships and transactions.
If only there was a database that supported full text searching on transactional tables. (See my signature...)
