InnoDB | WordPress.org

yz
(@yz)

13 years, 4 months ago

Hi, can WordPress use InnoDB? If so, how do I tell WordPress to use InnoDB? If I have an existing database, how do I migrate it to InnoDB? (I tried simply dumping and loading back the tables but with ENGINE=innodb instead of myisam, but that doesn’t work.)

Viewing 4 replies - 1 through 4 (of 4 total)

Thread Starter yz
(@yz)

13 years, 4 months ago

Just to add some more info on the specific error I got, it was that FULLTEXT indexes are not supported by innodb.

lury
(@lury)

13 years, 4 months ago

yes, you cannot use fulltext indexes with innodb so you better switch to some search engine or use google search on your site.

read this first: http://www.619cloud.com/blog/5-essential-steps-for-hosting-wordpress/

you have script to generate sql to convert engine for each table

Thread Starter yz
(@yz)

13 years, 4 months ago

Turns out that WP *is* compatible with InnoDB – it was just a plugin I was using (YARP) that relied on fulltext indexes.

davidmstokes
(@davidmstokes)

12 years, 5 months ago

InnoDB supports full-text searches starting with 5.6,

And you can use the MySQL statement ‘ALTER TABLE wp_posts ENGINE=Innodb’ to convert the tables.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘InnoDB’ is closed to new replies.

Tags

InnoDB

In: Fixing WordPress
4 replies
3 participants
Last reply from: davidmstokes
Last activity: 12 years, 5 months ago
Status: not resolved

Topics

Topics with no replies

Non-support topics

Resolved topics

Unresolved topics

All topics