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?