Reading Mysql Binlog in talend

[Karthick4]

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

[Anonymous]

Hello,

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

Best regards

Sabrina

[Karthick4]

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