Search code examples
backupsearch-enginesphinx

How to export or backup Sphinx indexes

I have a Sphinx install on a server. I would like to copy the data created by sphinx during indexations (basically for backup or to provide exact copy for dev team).

Do I have another solution than copying files from {your_install}/data/*.sp* ?

(In this case, .spl files are protected, but they are empty, are they usefull or there are only lock files ?)

Solution

  • the .spl is only a lockfile - no there is no need to back it up.

    I think the only option is to backup the data files as you note.

    Note if you have RT indexes, then there might be other extensions (I think .ram). You should also backup the Binlog. Although do see 'FLUSH RTINDEX' - that makes for cleaner backups.