# pblog

**Repository Path**: TianCiwang/pblog

## Basic Information

- **Project Name**: pblog
- **Description**: 解析mysqlbinlog
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2024-05-06
- **Last Updated**: 2024-05-06

## Categories & Tags

**Categories**: Uncategorized

**Tags**: MySQL, mysqlbinlog

## README

# pblog

#### 介绍
解析mysqlbinlog

#### 使用说明

```python
(venv) [root@app1 pblog]# python main.py 
==========================================================================================
Command line options :
    --help                  # OUT : print help info.
    -f, --binlog            # IN  : binlog file path. (required)
    -o, --outfile           # OUT : output rollback sql file. (time+rollback.sql)
    -h, --host              # IN  : host. (default '127.0.0.1')
    -u, --user              # IN  : user. (required)
    -p, --password          # IN  : password. (required)
    -P, --port              # IN  : port. (default 3306)
    --start-position        # IN  : start position. (default '4')
    --stop-position         # IN  : stop position. (default '1362365054815265219931015')
    -d, --database          # IN  : database (required).
    --rollback-type         # IN  : update or delete (required).

Sample :
   shell> python binlog_rollback.py -f 'mysql-bin.000001' -o '/tmp/rollback.sql' -h 192.168.0.1 -u 'user' -p 'pwd' -P 3307 -d dbname
```