Examine this snippet from the binary log file named binlog.000036:
The rental table was accidentally dropped, and you must recover the table.
You have restored the last backup, which corresponds to the start of the binlog.000036 binary log.
Which command will complete the recovery?
To recover the rental table, you need to play back the binary log until just before the DROP TABLE statement. The DROP TABLE statement starts at position 500324, and we need to stop before it gets executed. Therefore, using the --stop-position=500453 will ensure that the binary log events are replayed up to but not including the DROP TABLE statement, thus preventing it from being dropped again.
A. use position over time
sorry, A does not include the statement. Execution stops at that poisition, so anything after it won't execute. B is it, because its timestamp is AFTER that point.