Two suggestions: a) Noticed that your dih spec in the solrconfig.xml seems
to to refer to "db-data-config.xml" but you said that your file was
db-config.xml. You may want to check this to make sure that your file
names are correct. b) what does your log say when you ran the import
process?
- Bill
-----Original Message-----
From: do3do3
Sent: Sunday, October 17, 2010 8:29 AM
To: solr-user@lucene.apache.org
Subject: indexing mysql database
i try to index table in mysql database,
1st i create db-config.xml file which contain
<dataSource type="JdbcDataSource" name="1stTrial"
Driver="com.mysql.jdbc.Driver" encoding="UTF-8"
url="jdbc:mysql://localhost:3306/(database name)"
user="(user)" password="(password)" batchSize="-1"/>
followed by
<entity dataSource="1stTrial" name="(table name)" pk="id" query="select *
from (table name)">
and defining of table like
<field column="id" name="ID"/>
<field column="Text1" name="(field name)"/>
2nd i add this field in schema.xml file
and finally decide in solronfig.xml file the db-config.xml file as
<requestHandler name="/dataimport"
class="org.apache.solr.handler.dataimport.DataImportHandler">
<lst name="defaults">
<str name="config">db-data-config.xml</str>
</lst>
</requestHandler>
i found index folder which contain only segment.gen & segment_1 files
and when try to search no result i got
any body can present a help ???
thanks in advance
--
View this message in context:
http://lucene.472066.n3.nabble.com/indexing-mysql-database-tp1719883p1719883.html
Sent from the Solr - User mailing list archive at Nabble.com.
