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]

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

If you database source and database destination have the same structure. You don't really need talend. Just an import/Export with any MySQL client (phpMyadmin, MySQLQueryBrowser, etc.)
If you table structure are differents or you you want to transform some data. Talend can do that perfectly.
1) Open new projet
2) Add job
3) Add data base connection source
4) Add data base connection destination
5) Add tMysqlInput (drag and drop table from source table list as input)
6) Add tMysqlOutput (drag and drop table from destination table list as output)
7) Add tMap component
😎 Connect all your compenent
9) Verify compenent parameters
10) Execute you job and have fun
This video may help you to start.