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
- Search query example using Mysql protocol
- Connect to Manticoresearch using Mysql client
- JSON over HTTP protocol example
- Using regex in search
- How to run indexing for specific plain index
- How to index TSV data
- List all indexes on the server
- Server config example
- Searching data in real time (RT) index using SQL
See more codes...