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!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables