Ians Ramblings Ian's ramblings, daily, ish

MySQL 5 and Sphinx

I just thought I would put some help points on compiling and installing Sphinx and SphinxSE with MySQL 5.0.37 to help anyone out there who is currently working on the same process.

1 download the mysql source for version 5.0.37 from http://downloads.mysql.com/archives/mysql-5.0/mysql-5.0.37.tar.gz

2 download sphinx source unpack it and the mysql source in the same root directory eg home/youruser/

3 from within the mysql source dir where sphinx source is in the same director cp ../sphinx-0.9.8.1/mysqlse/sphinx.5.0.37.diff ./

4 patch -p1 < sphinx.5.0.37.diff

5 sh BUILD/autorun.sh

6 cp -R ../sphinx-0.9.8.1/mysqlse sql/sphinx

7 ./configure --prefix=/usr/local/mysql --with-sphinx-storage-engine (this is important as the sphinx instructions just mention the --with-sphinx-storage-engine, without the prefix mysql is very difficult to get started believe me

8 make (takes ages for mysql)

9 make install

10 cp support-files/my-medium.cnf /etc/my.cnf

11 cd /usr/local/mysql

12 chown -R mysql .

13 chgrp -R mysql .

14 bin/mysql_install_db --user=mysql

15 chown -R root .

16 chown -R mysql var

17 /usr/local/mysql/bin/mysqld_safe --user=mysql &

18 then complete the instructions for installing Sphinx on Linux, complete the sphinx.conf and run the indexer

Instructions for compiling with SphinxSE
http://www.sphinxsearch.com/docs/current.html#sphinxse

Instructions for installing Sphinx on Linux
http://www.sphinxsearch.com/docs/current.html#installing

Instructions for installing MySQL from source
http://dev.mysql.com/doc/refman/5.1/en/quick-install.html