manticoresearchHow to index data from Mysql
source text_src {
type = mysql
sql_host = localhost
sql_user = usr
sql_pass = pwd
sql_db = db
sql_query_pre = SET NAMES utf8
sql_query = SELECT id, name, description FROM test
}
index text_idx {
type = plain
source = text_src
path = /var/lib/manticore/data/test
}ctrl + ctext_srcname of the source block | type = mysqlwe're going to index data directly from Mysql |
localhostMysql host | usrMysql auth user |
pwdMysql auth password | dbMysql db name |
sql_query_prequery to execute before getting data | sql_queryquery to get data for indexing |
text_idxname of the index block and our index | /var/lib/manticore/data/testpath to store index files in |
More of Manticoresearch
- Server config example
- Searching data in real time (RT) index using SQL
- How to index data from PostgreSQL
- JSON over HTTP protocol example
- Find Manticore search version
- List all indexes on the server
- Using regex in search
- How to reindex all plain indexes
- How to install Manticore search on Ubuntu 22.04
See more codes...