分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
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 a