MySQL Point In Time Recovery | PITR | Mysqlbinlog | Binlog2sql | Tutorial 6
HTML-код
- Опубликовано: 12 сен 2024
- 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/dan... && cd binlog2sql
pip install -r requirements.txt
Thanks!
Great video extremely helpful, I really enjoy your content Mr. great job.
Have you ever tested this in your local environment? 😁
Excellent video, very illustrative.
Good explanation bro...
interesting brother please make more videos s
thanks for Binlog2sql details
good tutorial bro!!. keep it up.
How can we move from mysql> to [root@localhost sql]# ?
When is your course going live?
In a week
I have recordings as well if you interested
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
can you please share content of "fg" and mysql alias you are using to login , thanks
bro ippudu 1 row ni update chesi same row ni taruvatha deletechesestea --flashback lo
updated and
old before updated
2 results kanapadataya
Which terminal you are using to perform this task Sir ?
Windows terminal
You are Sri Sakthivel ?
Yes
@@hercules7sakthi I read your Percona articles ... very helpful. Thanks Lot
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?