php - 将 Sphinx 索引数据导出到 SQL

Question

是否可以将sphinx索引数据导出到SQL中，以便导入到原表中？开发环境中的一个表被删除，而我们忽略了进行备份。它适用于 vBulletin。需要恢复 pm 和 pmtext 表。

Answer 1

如文档中所述:

Note that the original contents of the fields are not stored in the Sphinx index. The text that you send to Sphinx gets processed, and a full-text index (a special data structure that enables quick searches for a keyword) gets built from that text. But the original text contents are then simply discarded. Sphinx assumes that you store those contents elsewhere anyway.

抱歉。