数据库运维
记录DBA学习成长历程

案例-使用binlog日志进行数据恢复

1. 
[(none)]>create database binlog charset utf8;
2. 
[(none)]>use binlog;
[binlog]>create table t1(id int);
3. 
[binlog]>insert into t1 values(1);
[binlog]>commit;
[binlog]>insert into t1 values(2);
[binlog]>commit;
[binlog]>insert into t1 values(3);
[binlog]>commit;
4. 
[binlog]>drop database binlog;
此部分内容加密,请输入密码查看
赞(1)
MySQL学习笔记 » 案例-使用binlog日志进行数据恢复