I'm working on a project with a client. The client has a MySQL Database with a few large tables (~100 million records each). I've pulled the initial data. I am required to sync the client's database to my database. Now whenever the client inserts a row in any of the tables, I should sync it to my table. However, there are some (very strict) restrictions. I cannot create triggers on client's tables. The tables may not have a dateTime column for me to recognise the creation time of a row. I do not wish to run a comparison between client's table vs mine(which will obviously take days just to identify a few 100 new insertions)
Is there any other way I can extract the newly inserted rows from client's tables?