MySQL Point In Time Recovery | PITR | Mysqlbinlog | Binlog2sql | Tutorial 6

In this video, I have explained how to perform the point in time recovery using the mysqlbinlog utility and the binlog2sql tool. If you have any questions, please comment.
Binlog2sql download link:
git clone github.com/danfengcao/binlog2... && cd binlog2sql
pip install -r requirements.txt
Thanks!

[@gregoryplaza]

Great video extremely helpful, I really enjoy your content Mr. great job.

[@ranvijaymehta]

thanks for Binlog2sql details

[@pankajsharma3608]

good tutorial bro!!. keep it up.

[@saravananr7681]

Good explanation bro...

[@Cult-Fan]

interesting brother please make more videos s

[@matteraf]

Have you ever tested this in your local environment? 😁
Excellent video, very illustrative.

[@user-mo8kh6ee3e]

How can we move from mysql> to [root@localhost sql]# ?

[@tyreddy8774]

if we updated 1 row and deleted that updated row ,then in --flashback can we see ,both row before deleted and row before updated.
and at begin of transation i saw the position 3613 next to begin but u gave 3531 wich is above begin (vedio time:-10:18) whats the difference

[@tyreddy8774]

bro ippudu 1 row ni update chesi same row ni taruvatha deletechesestea --flashback lo
updated and
old before updated
2 results kanapadataya

[@mayanks6728]

can you please share content of "fg" and mysql alias you are using to login , thanks

[@Ulta-Fulta]

Which terminal you are using to perform this task Sir ?

[@saravananr7681]

Windows terminal

[@notnull01]

When is your course going live?

[@hercules7sakthi]

In a week

[@hercules7sakthi]

I have recordings as well if you interested

[@ranvijaymehta]

You are Sri Sakthivel ?

[@hercules7sakthi]

Yes

[@ranvijaymehta]

@@hercules7sakthi I read your Percona articles ... very helpful. Thanks Lot

[@oah8465]

it does not work with mysql 8.0 keep showing the following error.
Traceback (most recent call last):
File "binlog2sql/binlog2sql.py", line 149, in
back_interval=args.back_interval, only_dml=args.only_dml, sql_type=args.sql_type)
File "binlog2sql/binlog2sql.py", line 46, in __init__
self.connection = pymysql.connect(**self.conn_setting)
File "/usr/lib/python2.7/site-packages/pymysql/__init__.py", line 90, in Connect
return Connection(*args, **kwargs)
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 706, in __init__
self.connect()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 931, in connect
self._get_server_information()
File "/usr/lib/python2.7/site-packages/pymysql/connections.py", line 1269, in _get_server_information
self.server_charset = charset_by_id(lang).name
File "/usr/lib/python2.7/site-packages/pymysql/charset.py", line 38, in by_id
return self._by_id[id]
KeyError: 255
any Ideas?