Comments (5)
你好,能贴下输出结果吗?
如果是DDL语句,正向解析不会过滤,flashback模式会忽略DDL
from binlog2sql.
请问「正向解析」怎么理解?我也遇到这个问题,-d -t 过滤不了。python 版本为2.6.6,执行以下
python binlog2sql/binlog2sql/binlog2sql.py -dtest -t1129 -h127.0.0.1 -P3306 -uback -p'xxxx' --start-file='mysql-bin.000396'
不是我想过滤的目标库和表,解析结果是把'mysql-bin.000396'里面的内容全部解析出来了。
from binlog2sql.
刚做了个测试。通过 source xxx.sql ,-B 过滤解析出来的怎么全是 delete 语句,不应该是 insert 吗?
from binlog2sql.
为避免之前db过滤包含ddl的困惑,我做了些改动。新加一个控制参数,--only-dml 用于控制解析SQL类型,默认只解析dml,现在db过滤不会再有ddl干扰。详见 #23 或最新文档
from binlog2sql.
@long904 导入数据后,直接解析出来是insert语句,-B是闪回模式,生成的是回滚语句,所以生成delete是对的
from binlog2sql.
Related Issues (20)
- 用起来都是泪 HOT 2
- 参数都无效 HOT 1
- 这个项目能使用本地binlog文件吗?云服务器的mysql binlog文件因为时效性都是备份到本地的
- 报编码错误,求解决方案
- win10下有编码问题。大神有没有有办法解决 HOT 2
- 解析出来的sql字段位置对应不上 HOT 1
- 解析阿里云drds的binlog报错
- 各位大佬,truncate某张表是不是无法恢复,我实测是这样的,有没有解决方案!!! HOT 1
- 如何解决解码错误的问题? HOT 2
- KeyError: 255怎么解决,数据库版本8.0.20,系统CentOS-7.4.1708 HOT 1
- 感谢!
- 对于mysql8 参数无效么。 HOT 1
- 欢迎使用canal2sql
- IndexError: list index out of range HOT 1
- 删除的语句值全为isnull HOT 1
- [设计讨论]脚本需要连接服务器的原因? HOT 5
- 请问下 当前是否支持mysql8.0.20 HOT 1
- 使用binlog2sql 分析腾讯云数据库的binlog报错log/mysql-bin.000048 not in mysql server HOT 1
- binlog2sql恢复 HOT 2
- 支持JSON字段 HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from binlog2sql.