使用 mysqlbinlog
工具恢复删除的数据库记录
初始条件:安装 mysql 数据库服务端并创建一个数据库,之后执行 reset master
命令清理 binlog
记录,然后执行命令创建存储过程和删除此存储过
程。
mysql> reset master;
Query OK, 0 rows aected (0.01 sec)
mysql> show master logs;
+------------------+-----------+
|
Log_name
|
File_size
|
+------------------+-----------+
|
mysql-bin.000001
|
106
|
+------------------+-----------+
1 row in set (0.00 sec)
mysql> delimiter //
mysql> CREATE
PROCEDURE `sp_getcustomerquantity`(out
quantity
int)
-> READS SQL DATA
-> BEGIN
-> select count(*) into quantity from customers;
-> END
-> //
Query OK, 0 rows aected (0.00 sec)
mysql> delimiter ;
mysql> show master status;
+------------------+----------+--------------+------------------+
|
File
|
Position
|
Binlog_Do_DB
|
Binlog_Ignore_DB
|
+------------------+----------+--------------+------------------+
|
mysql-bin.000001
|
323
| | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)