XF 2.2 xf_search_index crashed - struggling to run repair

[pauljwilliams]

As title, xf_search_index is crashed. Im trying to run a repair from the command line, but cannot get it to complete without the connection being closed.

Is it possible to get a table definition so I can just drop and recreate it, or do I need to just keep running the command until it completes?

 

[AndyB]

Use phpMyAdmin to empty the xf_search_index table.