converting mysql binlogs to text format without using mysqlbinlog tool

Asked Nov 07 '16 at 06:17

Active Nov 07 '16 at 06:41

Viewed 396 times

I need to convert the mysql binlogs to text format in PHP script. I am aware of using mysqlbinlog tool to convert it to text. But I am not supposed to run any system commands(or any shell command) in my script.

Is there any other way to do it using PHP?

Thank you for any help.

edited Nov 07 '16 at 06:41

asked Nov 07 '16 at 06:17

Ahalya Hegde

1,571
2
18
41

"Not supposed to use any system commands"? What is that supposed to mean? What about doing it without computers? That's equally absurd. Use the right tool for the job, and if that's `mysqlbinlog`, then use that. – tadman Nov 07 '16 at 06:36
ok, updated the question now, What I meant was I cannot run any commands in my php script. So is there any other method to convert it in php? @tadman – Ahalya Hegde Nov 07 '16 at 06:45
https://dev.mysql.com/doc/internals/en/binary-log-versions.html Describes the internal format of a binlog file – Michel Feldheim Nov 07 '16 at 07:20
Is this a school assignment? – Michael - sqlbot Nov 07 '16 at 09:59
This seems like a very risky undertaking. Why can't you run any commands? – tadman Nov 07 '16 at 15:33
you can look for any binlog reader php library and use that. – Arindam Nayak Jan 29 '20 at 12:20

converting mysql binlogs to text format without using mysqlbinlog tool

0 Answers0