topic Re: mysql dump/export in Talend Studio

mysql dump/export

Anonymous — Sat, 16 Nov 2024 13:37:51 GMT

Before each running of my job I wish to make a mysql backup to a file of the effected tables. Is this possible with one of the available components?

Re: mysql dump/export

Anonymous — Fri, 25 Dec 2009 02:32:13 GMT

Hello
You can use the tMysqlRow component which is used to execute sql statement.
Best regards

shong

Re: mysql dump/export

Anonymous — Fri, 27 Jan 2012 08:27:20 GMT

what about using mysqldump command to dump a number of tables?
we have over 20 tables that we want to transfer between database servers using a taldend job, and going table by table is going to be crazy.

Re: mysql dump/export

Anonymous — Fri, 27 Jan 2012 10:09:57 GMT

Hello
What you can do is sometihing like: mysqldump -u -p mydatabase table1 > table1.sql, you can do one command for each command you want.

Re: mysql dump/export

Anonymous — Thu, 11 Oct 2012 07:29:01 GMT

Hello
What you can do is sometihing like: mysqldump -u -p mydatabase table1 > table1.sql, you can do one command for each command you want.

which component should i use for that? tsystem?

Re: mysql dump/export

Anonymous — Thu, 11 Oct 2012 08:48:28 GMT

which component should i use for that? tsystem?

Correct, or SSH

Re: mysql dump/export

Anonymous — Wed, 10 Jul 2013 21:40:04 GMT

I had a mysqldump statement working fine in a tSSH component and I wanted to migrate it to a tsystem as the dump need to be done on the same machine (it saved my to manage login and password for the tSSH).
So I've been cut and past the code from tSSH to tSystem using Single Command. The code is (I've all my context variable set up properly)

"mysqldump -u " context.Login " -p" context.Password " --databases " context.dbname " > /home/" context.source "/Archive/" TalendDate.getDate("YYYYMMDD_hhmmss") "_" context.source ".sql"

Then in the standard output I've the following choices:
- to console: print the command on screen but doesn't run it (useful to check that variable are properly used but doesn't do the job)
- to global variable: data is passed on to an output variable linked to the tSystem component. Not really what I want to do
- to console and to global variable: same comment as previously
- normal: data is passed on to the component that comes next, so I plug a tFileDelimited after and it wrote the mysqldump statement instead of the proper dump
So I guess I am missing something, thanks for your help.

tSystem documentation page:
https://help.talend.com/search/all?query=tSystem&content-lang=en

Re: mysql dump/export

Anonymous — Thu, 11 Jul 2013 04:19:54 GMT

Hi magdmartin
Export the Error output to the console, it will print the error on the console if it has error when executing this SQL. From your command, I see the only place in question is the date pattern for the method TalendDate.getDate(), it should be:
TalendDate.getDate("yyyyMMdd_hhmmss") or TalendDate.getDate("yyyyMMdd_HHmmss")
Shong

Re: mysql dump/export

Gulshan_Kumar — Tue, 11 Aug 2020 01:08:40 GMT

Use the following command in tsystem by using home directory where mysql server is installed.

"cmd /c mysqldump -v -h localhost --user=root --password=123456 --all-databases > c:/temp/data/etldump.sql"

Regards

Gulshan Kumar