Shulou(Shulou.com)05/31 Report--

This article mainly introduces "do not compile reinstall MySQL database directly install sphinx method", in the daily operation, I believe that many people do not compile reinstall MySQL database directly install sphinx method problems, editor to consult all kinds of information, sort out a simple and easy-to-use method of operation, hope to answer the "do not compile reinstall MySQL database directly install sphinx method" to help! Next, please follow the editor to study!

How to install MySQL directly without compiling and reinstalling sphinx database

Note: the version of the mysql source package must be the same as the currently running mysql version!

First download the sphinx plug-in package. What I'm running here is mysql-5.1.48.

Download: sphinx:wget http://sphinxsearch.com/downloads/sphinx-0.9.9.tar.gz

Decompress: tar-xzvfsphinx-0.9.9.tar.gz

Create a sphinx folder:

Mkdirmysql-5.1.48/storage/sphinx

Copy all files under mysqlse in the sphinx directory to storage/sphinx in the mysql directory:

Cp-rsphinx-0.9.9/mysqlse/mysql-5.1.48/storage/sphinx

Go to the decompressed directory of the mysql source code package:

Cdmysql-5.1.48shBUILD/autorun.sh./configuremake

Note: here you can go to make instead of install.

Copy the good make files to the currently running mysql directory:

Cpstorage/sphinx/.libs/ha_sphinx.*/usr/local/mysql/lib/plugin

How to install MySQL directly without compiling and reinstalling sphinx database

Change the owner:

Chownmysql.mysql/usr/local/mysql/lib/plugin/*

Log in to mysql to load the sphinx engine module:

/ usr/local/mysql/bin/mysql-uroot-p-hlocalhost

Load the sphinx enclosure:

Mysql > INSTALLPLUGINsphinxSONAME'ha_sphinx.so'

Check that the engine module is loaded properly:

Mysql > showengines

Installation complete! If you want to uninstall enclosure use:

Mysql > UNINSTALLPLUGINsphinx

You can uninstall it.

At this point, on the "do not compile reinstall MySQL database directly install sphinx method" on the end of the study, I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.