Shulou(Shulou.com)05/31 Report--

Today, I will talk to you about the example analysis of mysql flashback flashback-5.7, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following for you. I hope you can get something according to this article.

1. First confirm the location of the misoperation.

two。 Use tool flashback

[root@Yun-MySQL02 lib64] # / soft/mysqlbinlog-vv-- start-position=331-B-- skip-gtids / databak/3306/mysql-bin.000043 | / usr/local/mysql/bin/mysql-uroot-p`cat / etc/sqlpass `- P3306-h227.0.0.1 test

-if gtid is enabled, it is best to use skip-gtids or an error will be reported.

[root@Yun-MySQL02 lib64] # / usr/local/mysql/bin/mysql-uroot-p`cat / etc/sqlpass `- P3306-h227.0.0.1 test

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.