db to db migration

[Anonymous]

Can anybody help me how to migrate one mysql db to another mysql db present on another host machine? I am really blank about which components to use to achieve this data migration. Any kind of help will be really appreciated. Thanks

[Anonymous]

Hi
Do you want to migrate the whole db or only some of tables? Please learn the usage of tMysqlInput and tMysqlOutput components on user documentation.

Best regards
Shong

[Anonymous]

I want to migrate the whole db. Can you help me how to achieve that using tMySqlInput and tMySqlOutput?

[Anonymous]

Hi,
just a few more hints ...
- tMySQLConnection
|
- tMySQLTableList --- tMySQLInput --- tMySQLOutput

Hope this helps

Best regards
Christian

[Anonymous]

I am using mysql 4.1 and I am getting this exception and unable to load the table information 😞
Exception in component tMysqlTableList_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'information_schema.tables' doesn't exist
Can anybody help?

[Anonymous]

Hi,
I just found this information :

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.

So, with MySQL 4.1 the tables are not accessible via information_schmea.tables ... 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!
Maybe this information is still helpful

Good Luck!
Christian

: http://www.thegeekstuff.com/2008/11/overview-of-mysql-information_schema-database-with-practical-exa...

[Anonymous]

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 just checked the tMySQLConnection component. You can choose between two values for DB Version: Mysql 5 and Mysql 4
Have you checked, that you realy set this option to Mysql 4?
Regards,
Christian

[Anonymous]

I have just checked with it and still getting the same exception

[Anonymous]

I would also like to chime in that I am attempting to do something similar with the tMySQLTableList component, and am receiving the same error message. Is this component only compatible with MySQL 5? There is nothing in the documentation that I can see that states that. If there is no quick solution then this needs to be entered into the Bugtracker system since this is blocking our progress.
Thanks,
Ryan

[Anonymous]

What Collation are you all using?
I'm trying to get tMSSQLTableList working on SQL Server 2008 with Latin1_General_BIN and in MSSQL the View is INFORMATION_SCHEMA.TABLES where the error comes back as information_schema.tables (invalid object name)
Can anyone help?