mysql 基于时间点恢复

最新推荐文章于 2023-10-12 14:49:24 发布

外太空有云

最新推荐文章于 2023-10-12 14:49:24 发布

阅读量530

点赞数

本文链接：https://blog.csdn.net/qq_43682661/article/details/87867074

版权

                        
          MySQL基于时间点恢复(PITR)   MySQL的PITR主要是通过mysqldump来做全备，然后通过log-bin来恢复到某个时间点，达到PITR的目的确认log_bin是否打开mysql> show global variables like 'log_bin';+---------------+-------+| Variable_name | Value |+---------------+-------+| log_bin       | ON    |+---------------+-------+1 row in set (0.00 sec)当前frank数据中有表t1mysql> use frank;Reading table information for completion of table and column namesYou can turn off this feature to get a quicker startup with -ADatabase changedmysql> show tables;+-----------------+| Tables_in_frank |+-----------------+| t1              |+-----------------+1 row in set (0.00 sec)在时间点a做备份frank数据库[root@c12 data]# mysqldump -u root -p --protocol tcp --host  127.0.0.1 --port 3306 --flush-logs --databases frank >frank.sqlEnter password: 在时间点b 创建表frank.t2mysql> create table t2 (a int);Query OK, 0 rows affected (0.00 sec)mysql> insert into t2 values(