Myluzh Blog

Strive to become a dream architect.

mysql通过log_bin恢复数据

2023-12-27 myluzh MySQL

0x01 使用binlog恢复数据 1、登录mysql [root@blog ~]# mysql -u root -p Enter password: 2、查看bin_log是否开启 log_bin=ON,那么恭喜你,还有恢复的可能。 mysql> show variables like 'log_%'; +----------------------------------------+----------------------------------+ | Variable_name | Value | +----------------------------------------+----------------------------------+ | log_bin | ON | | log_bin_basename | /www/se...

阅读全文>>

标签: mysql logbin 恢复 数据

评论(0) (138)