Sphinx: Initialize Real Time Index

Question

I would like to migrate one of the sphinx index into real time. However, rt index doesn't take a source and its initialization is kinda messy. Is there a way to migrate existing index into real time without a lot of scripting?

Answer 1

I am glad that my presentation was helpful, but now Sphinx has new command which help migrate from original to real-time indexes: attach index

It is simple as:

ATTACH INDEX diskindex TO RTINDEX rtindex

BTW, I have wrote a blog post which describe attach index command in details.

Answer 2

At the moment no official way exists. Only custom solutions. In this interesting document (PDF) there is one of the ways mentioned:

mysqldump -uroot blog users > users_dump.sql
mysql -P9306 < users_dump.sql

Regards.