Re: indexing mysql database
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.comwrote: 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=configdb-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.
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=configdb-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.
Re: indexing mysql database
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=configdb-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.