XF 2.3 Upgrade to 2.3 – search index conversion to innodb

[TLDR]

Hello,

the other day, I was upgrading my XenForo from i dunno 2.1.x or something (or maybe an early 2.2) to the latest version and it went well.

Now I'm reading this:

All core and first-party add-on tables are converted to InnoDB when upgrading to 2.3, except for the search index which must be converted manually.

And my question would be: How would I do this, like just fire up Sequel Ace, find xf_search_index and just change Type to InnoDB?

I've looked in the announcement for 2.3.0 and also in the manual, but was unable to find innodb mentioned.

Thank you!

 

[Jeremy P]

You can run the following CLI command:

php cmd.php xf:convert-search-innodb

 

[TLDR]

Thank you for your response.

And that would be it? Like fire and forget, no config.php change or something?

 

[Jeremy P]

The CLI command will remind you, but you will need to update config.php afterwards:

$config['searchInnoDb'] = true;

 

[TLDR]

Yeah just as I was doing it, I saw that the CLI did a great job in guiding me through it, and also mentioned this.

Thank you again, it's done now