Connections-Business-Directory / Connections

Directory Plugin for WordPress
https://connections-pro.com
GNU General Public License v2.0
26 stars 18 forks source link

Detect table engine before doing FULLTEXT #310

Closed shazahm1 closed 10 years ago

shazahm1 commented 10 years ago

ref: http://stackoverflow.com/questions/213543/how-can-i-check-mysql-engine-type-for-a-specific-table

SELECT TABLE_NAME, ENGINE FROM information_schema.TABLES where TABLE_SCHEMA = 'dbname'

Replace "dbname" with your database name.

Use WP constant DB_NAME for the dbname.

related #309

shazahm1 commented 10 years ago

Closing b/c I'm implementing the solution in #309.