Import data from mysql dump to Elasticsearch

Elastic Stack Logstash
1

I want to import data from .sql file (backup created from mysql db with extension .sql) to elasticsearch. What is the way of doing that?

2

What is the format of the data?

3

Badger, It is mysql table data but with .sql extension. for example abc.mysql

4

Any direct way of importing it? Without being restored on mysql and then ingesting it?

5

Not that I am aware of. I think you need to restore and use the JDBC input plugin.

6

Ok. Thanks, That is the solution I am aware of. I was searching the direct method of doing that

7

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.