RELOAD INDEX syntaxΒΆ

RELOAD INDEX idx [ FROM '/path/to/index_files' ]

RELOAD INDEX allows you to rotate indexes using SphinxQL.

It has two modes of operation. First one (without specifying a path) makes Manticore daemon check for new index files in directory specified in path. New index files must have a idx.new.sp? names.

And if you additionally specify a path, daemon will look for index files in specified directory, move them to index path, rename from index_files.sp? to idx.new.sp? and rotate them.

mysql> RELOAD INDEX plain_index;
mysql> RELOAD INDEX plain_index FROM '/home/mighty/new_index_files';