MySQL log recovery mistakenly deleted record

1. Query log is turned on

Show variables like "Log_";

2. Which log file is used for the query

Show master status;

3. What time is the position deleted by mistake?

/usr/local/mysql/bin/mysqlbinlog/usr/local/mysql/var/mysql-bin.000075

In other words, 610 is the drop data table, then restore to 505 can

4. Recovery

/usr/local/mysql/bin/mysqlbinlog--stop-position= "505"/usr/local/mysql/var/mysql-bin.000075 | Mysql-uroot-proot (Specific reference mysqlbinlog usage)

5. View recovery Status

6. Other

MySQL log recovery mistakenly deleted record