# mysql -P9306 -h0
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 33
Server version: 3.5.4 13f8d08d@201211 release git branch HEAD (no branch)
Copyright (c) 2000, 2021, Oracle and/or its affiliates.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE TABLE testrt(title text, content text, counter int);
ERROR 1064 (42000): CREATE TABLE requires data_dir to be set in the config file
despite the fact that in /etc/manticoresearch/manticore.conf I have
I donât understand where heâs declared it in two places. I am running into the same issue after adding a csv source and plain index. Iâm using the default config from /etc/manticoresearch without modifying anything in the file other than adding source and index for a csv file.
If you youse plain indexes with sources and running indexer - remove âdata_dirâ from searchd section. It is not compatible with old way of working with the indexes.
I.e. - config either contains âdata_dirâ in searchd section, and no sources/indexes.
Either you put indexes into config - but then you have to remove data_dir.
Old way is have indexes in the config, fill them with âindexerâ (for plain) or with âinsertâ (for rt) and manage all these files yourself.
New way is REMOVE all indexes definitions from config and add âdata_dirâ to searchd section.
Then you can create indexes with ddl statement âcreate tableâ, fill it with âinsertâ, achieve replication.
Plain indexes âas isâ are not available in that mode, tool âindexerâ also is not necessary.