维帝博客 - Solr笔记(2).将Mysql的数据导入至Solr中

### 1. 在Solr的Core核心目录下创建一个data-config.xml

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/20201231104530d9bfe3f6f818482b97824ccf63e1495d/clipboard.png)

data-config.xml内容

```xml
<?xml version="1.0" encoding="UTF-8" ?>
<dataConfig>
    <dataSource type="JdbcDataSource" driver="com.mysql.cj.jdbc.Driver" url="jdbc:mysql://localhost:3306/test?useUnicode=true&amp;characterEncoding=utf8&amp;useSSL=false&amp;serverTimezone=GMT%2B8" user="root" password="root" encoding="UTF-8"/>
    <document>
        <entity name="article" query="select `id`,`title` from article">
            <field column="id" name="id" />
            <field column="title" name="title" />
        </entity>
    </document>
</dataConfig>
```

### 2.打开核心下的conf/managed-schema

![]('https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/20201231104901b834bc6ad52743849c76be85353bc387/clipboard.png)

在field下方加入以下内容

```xml

    <fieldType name="int" class="solr.TrieIntField" precisionStep="0" positionIncrementGap="0"/>
    
    <field name="id" type="int" multiValued="false" indexed="true" required="true" stored="true"/>
    <field name="title" type="text_general" indexed="true" stored="true" />
```

id字段以在文件中出现,所以无需添加.>id字段以在文件中出现,所以无需添加.

### 3.打开核心下的conf/solorconfig.xml

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/2020123110514228a731255e294136b33a588ae2942a48/clipboard.png)

找到<span style="color:#ffbf00"><b>requestHandler</b></span>标签,在同级下加入以下内容

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

### 4.添加Jar包

将solr/dist目录下的solr-dataimporthandler-8.7.0.jar和Mysql驱动包

放入solr/server/solr-webapp/webapp/WEB-INF/lib文件夹下

### 5.启动solr,进入该菜单下,导入数据(solr从8.6版本就不推荐这种方式导入数据,并且可能在后续版本删除此导入方法)

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/2020123110551085ee4d91600949fab1098ef9564c2e69/clipboard.png)

### 6.导入后查看导入成功后的数据

![](https://veddy-blog.oss-accelerate.aliyuncs.com/assets/images/article/2020123110554269ac51e898b747be96b8f41ede0f072b/clipboard.png)