# How to import mysql data into elastic search **URL:** \ **Category:** Elasticsearch\ **Created:** [October 11, 2018, 3:40pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085 "2018-10-11T15:40:14Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 11, 2018, 3:40pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/1 "2018-10-11T15:40:14Z")
hi, i need to know about how to import the mysql data into elasticsearch, can u people please explain about what are software required for kibana visualize. i'm not clearly understand about procedures, what are steps i need to follow? please explain about the flows, how the data is imported in elasticsearch and how it goes to kibana, i googled many times, but i'm facing many issues. please provide some sample example from installation to kibana visuals. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [October 11, 2018, 4:07pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/2 "2018-10-11T16:07:10Z")
You can use something like logstash and its jdbc input to read from your DB and push json to elasticsearch. > but i'm facing many issues. Which are? ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 12, 2018, 3:56am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/3 "2018-10-12T03:56:30Z")
Error: Could not find or load main class folder\logstash-6.4.1\logstash-6.4.1\logstash-core\lib\jars\commons-codec-1.11.jar; ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 12, 2018, 4:08am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/4 "2018-10-12T04:08:31Z")
input { jdbc { jdbc\_connection\_string =\> "jdbc:mysql://192.168.9.231:3306/sam\_sit3" # The user we wish to execute our statement as jdbc\_user =\> "Test" jdbc\_password =\> "\*\*\*\*\*" # The path to our downloaded jdbc driver jdbc\_driver\_library =\> "D:\New folder\mysql-connector-java-5.1.47-bin.jar" jdbc\_driver\_class =\> "com.mysql.jdbc.Driver" # our query statement =\> "SELECT \* FROM tbl\_softwarelicenseinventory;" } } output { elasticsearch { hosts =\> "192.168.7.231:9200" index =\> "softwares" document\_type =\> "software" document\_id =\> "%{SoftwareLincenseInvetory\_Id}" } } these are the inputs given in config file, while running it i'm facing errors,. ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [October 12, 2018, 3:46pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/6 "2018-10-12T15:46:40Z")
> [@Nethaji](#): > > Error: Could not find or load main class folder\logstash-6.4.1\logstash-6.4.1\logstash-core\lib\jars\commons-codec-1.11.jar; This is probably a bad installation of Logstash. Not sure what you did... Make sure you are following the instructions here: [Installing Logstash | Logstash Reference [8.11] | Elastic](https://www.elastic.co/guide/en/logstash/current/installing-logstash.html) ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 15, 2018, 7:37am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/7 "2018-10-15T07:37:26Z")
Hi, I imported data from mysql to kibana, but in kibana it shows only one row. how to get the full data ? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [October 15, 2018, 8:50am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/8 "2018-10-15T08:50:56Z")
Probably you are using the same `_id` for all documents... That's a blind guess though as I have no idea of what you are doing. ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 15, 2018, 1:13pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/9 "2018-10-15T13:13:03Z")
No, i'm used different id ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 15, 2018, 1:19pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/10 "2018-10-15T13:19:43Z")
i took the primary key in every mysql table as id ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 17, 2018, 3:54pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/11 "2018-10-17T15:54:55Z")
Hi, i'm having doubt on creating pie chart, i want to create dashboard based on two index, then only i can achieve the correct output. but in kibana visual there is only one field is available, how to select multiple fields and how to join two index? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [October 17, 2018, 5:57pm UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/12 "2018-10-17T17:57:05Z")
That's probably a #kibana question. You should ask there. As for elasticsearch, there's not really join support unless you use parent / child feature. But Kibana does not support this. ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 19, 2018, 5:00am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/14 "2018-10-19T05:00:28Z")
thank you ---
**Author:** ![Nethaji](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/nethaji/32/72803_2.png) [@Nethaji](https://discuss.elastic.co/u/Nethaji)\ **Post date:** [October 19, 2018, 5:03am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/15 "2018-10-19T05:03:34Z")
is possible to create if conditional statement in elasticsearch? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [October 19, 2018, 5:38am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/16 "2018-10-19T05:38:48Z")
No it's not. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [November 16, 2018, 5:38am UTC](https://discuss.elastic.co/t/how-to-import-mysql-data-into-elastic-search/152085/17 "2018-11-16T05:38:49Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.