Also, the little-advertised DIH debug page can help, see: solr/admin/dataimport.jsp
Best Erick On Sun, Oct 17, 2010 at 11:56 AM, William Pierce <evalsi...@hotmail.com>wrote: > 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. >
