solr从mysql数据库导入到索引库

1、需要mysql驱动包放入webapps/solr/WEB-INF/lib/

mysql-connector-java-5.1.20-bin.jar

2、/collection1/conf/solrconfig.xml

<!-- data config -->
 <requestHandler name="/dataimport" class="org.apache.solr.handler.dataimport.DataImportHandler">   
    <lst name="defaults">   
       <str name="config">data-config.xml</str>   
    </lst>   
 </requestHandler>

3、新建data-config.xml

<?xml version="1.0" encoding="utf-8"?>
<dataConfig> 
  <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/blog" user="root" password="password"/> 　　 
  <document name="blog"> 
    <entity name="article" query="select a.id,a.title,ac.content,u.email from article a  left join `user` u on (u.id=a.user_id) left join article_content ac on (ac.article_id=a.id) "> 
      <field column="id" name="id"/>  
      <field column="title" name="boTitle"/>  
      <field column="content" name="boContent"/>  
      <field column="email" name="boEmail"/> 
    </entity> 　　
  </document> 
</dataConfig>