Starting from MySQL 5, when you execute show databases command, information_schema will be listed in the database list. information_schema is a virtual MySQL database that stores metadata information of all the MySQL databases.
I think there is an option in the MySQL Connection element, where you can define what version of MySQL you are using. I dont't have a 4.x version at hand right now. Sorry!
I want to migrate the whole db. Can you help me how to achieve that using tMySqlInput and tMySqlOutput?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema