topic Re: Reading Mysql Binlog in talend in Talend Studio

Reading Mysql Binlog in talend

Karthick4 — Sat, 16 Nov 2024 04:56:00 GMT

Hi All

I want to read MySQL binlog file in talend & convert it to .txt or .csv.

after converting the file look like as attached doc below from that file i need to get some part of data like from Insert into to commit & this will continue as many insert & commit in file. Thanks& regards

Re: Reading Mysql Binlog in talend

Anonymous — Tue, 20 Aug 2019 10:35:30 GMT

Hello,

Could you please elaborate your case with an example with expected output result?

Best regards

Sabrina

Re: Reading Mysql Binlog in talend

Karthick4 — Tue, 20 Aug 2019 11:32:05 GMT

Hi Xdshi, I am using tsystem component command to convert log file to .csv but am getting file path not found error. in tjava -------------- context.command_filepath ="mysqlbinlog -v -r"+" "+ StringHandling.DQUOTE("C:/Program Files (x86)/MySQL/Data/"+ ((String)globalMap.get("tFileList_1_CURRENT_FILE")) +".csv")+" "+StringHandling.DQUOTE(((String)globalMap.get("tFileList_1_CURRENT_FILEPATH"))); in tsystem component: -------------------------------- Home Directory: "C:/Program Files/MySQL/MySQL Server 8.0/bin>" cmd; context.command_filepath