I have to connect to a remote server. How can I connect to a specific database with a tSSH component? Or is there another method to get the dump working?
I can't connect to the server directly, because this is forbidden (I think, I get an IOException saying "There was a problem while connecting to XY"). A connection to the database via tDBInput works.
The steps mentioned in the backing up of MySQL need to be completed through terminal commands and you will have to use components like tSSH or tSystem.
So either you will have to get the access to the system to get exception to perform these operations or your administrators need to do this operation for you (you can create the job and give them as a shell script for execution).
Warm Regards, Nikhil Thampi
Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂
