You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by do3do3 <do...@hotmail.com> on 2010/10/17 17:29:23 UTC
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.
Re: indexing mysql database
Posted by Erick Erickson <er...@gmail.com>.
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 <ev...@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.
>
Re: indexing mysql database
Posted by William Pierce <ev...@hotmail.com>.
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.