MySQL 数据库误删除后的数据恢复操作说明

正文

请到「今天看啥」查看全文

"22" );

Query OK , 1 row affected ( 0.06 sec )

mysql > insert into customers values ( 3 , "zhangheng" , "27" );

Query OK , 1 row affected ( 0.09 sec )

mysql > select * from customers ;

+----+-----------+-----+

| id | name | age |

+----+-----------+-----+

| 1 | wangbo | 24 |

| 2 | guohui | 22 |

| 3 | zhangheng | 27 |

+----+-----------+-----+

3 rows in set ( 0.00 sec )

（2）现在进行全备份

[ root @ vm - 002 ~ ] # mysqldump -uroot -p -B -F -R -x --master-data=2 ops|gzip >/opt/backup/ops_$(date +%F).sql.gz

Enter password :

[ root @ vm - 002 ~ ] # ls /opt/backup/

ops_2016 - 09 - 25.sql.gz

参数说明：

-B：指定数据库
-F：刷新日志
-R：备份存储过程等
-x：锁表
–master-data：在备份语句里添加CHANGE MASTER语句以及binlog文件及位置点信息

（3）再次插入数据

mysql > insert into customers values ( 4 , "liupeng" , "21" );

Query OK , 1 row affected ( 0.06 sec )

mysql > insert into customers values ( 5 , "xiaoda" , "31" );

Query OK , 1 row affected ( 0.07 sec )

mysql > insert into customers values ( 6 , "fuaiai" , "26" );

Query OK , 1 row affected ( 0.06 sec )

mysql > select * from customers ;

+----+-----------+-----+

| id | name | age |

+----+-----------+-----+

| 1 | wangbo | 24 |

| 2

请到「今天看啥」查看全文