I need to synchronize database on server with database of local server upon active internet connection.
For its implementation I execute mysqlbinlog utility to read transaction logs and write the transaction queries into a sql file
Thereafter I execute sql file on database server to apply transaction updates on database on server
But I need to fetch only latest transaction logs within specific time interval across multiple binary log files . Please assist me in its implementation