# MySQL to ElasticSearch One DB multiple tables **URL:** \ **Category:** Logstash\ **Created:** [July 24, 2016, 8:02am UTC](https://discuss.elastic.co/t/mysql-to-elasticsearch-one-db-multiple-tables/56228 "2016-07-24T08:02:30Z")\ **Posts on this page:** 4\ **Page:** 1
**Author:** ![westealinfo](https://avatars.discourse-cdn.com/v4/letter/w/eada6e/32.png) [@westealinfo](https://discuss.elastic.co/u/westealinfo)\ **Post date:** [July 24, 2016, 8:02am UTC](https://discuss.elastic.co/t/mysql-to-elasticsearch-one-db-multiple-tables/56228/1 "2016-07-24T08:02:30Z")
Hello, I've just started using Elasticsearch. I have installed the JDBC Input Plugin to transfer data from our MySQL database to Elasticsearch. However, we have 200 tables in our database. We were wondering if there was a way to transfer all this to Elasticsearch. However we wanted it so that each table would have its own Index. So table 1 would have the index 'table1' and so on. I was wondering if this was possible instead of us doing it one by one. Thank you! ---
**Author:** ![Glen\_Smith](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/glen_smith/32/111656_2.png) [@Glen\_Smith](https://discuss.elastic.co/u/Glen_Smith)\ **Post date:** [July 25, 2016, 12:45am UTC](https://discuss.elastic.co/t/mysql-to-elasticsearch-one-db-multiple-tables/56228/2 "2016-07-25T00:45:41Z")
Moved to Logstash, to which the question is more relevant. ---
**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\ **Post date:** [July 29, 2016, 10:50am UTC](https://discuss.elastic.co/t/mysql-to-elasticsearch-one-db-multiple-tables/56228/3 "2016-07-29T10:50:57Z")
You need a separate jdbc input for each table you want to read from, but you could of course generate those configurations. ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 4:45am UTC](https://discuss.elastic.co/t/mysql-to-elasticsearch-one-db-multiple-tables/56228/4 "2017-07-06T04:45:57Z")