31 - MySQL Point in Time Recovery Using Event Positions |

This Mysql tutorial explains the general idea of using the binary log to perform a point-in-time-recovery
How to use and what is a binary log :
• 23 - What is Binary Lo...
• 24 - What is Binary Lo...
• 25 - Extracting statem...
• 26 - Extract Statement...
#mysql #mysqldba #tutorial #PITR #recover
Please Follow me on Social Media
Linkedin: / mughees-ahmed-oracle-m...
Twitter: / mughees52
Facebook: / mughees52

[@rajataggarwal5818]

very good content.

[@akshayghawade2550]

Thank you so much your video is really helpful 👌👌

[@mantootripathi7519]

Good work

[@pathaanzaarkhan2236]

Thanks for sharing dear

[@mughees52]

you are welcome

[@rajakumarchikkala8275]

Thank you very much for sharing Point-in-time recovery. It is very good tutorial. I liked it. I have small question here. If two of more databases in MySQL server and run mysqlbinlog command for Point-in-time recovery, will Binlog commands execute in all the respective databases? Means re-execute commands on other database if Binlog is having any transaction of other databases.
If that is the case, could you please suggest me how to resolve it.
Thanks in advance.

[@mughees52]

I took backup of only one database usually we take backup of all databases, and we will first restore that all databases backup and then apply bin log. bing log will have transection for every database so it will recover all databases even if you drop them all ...

[@alaabadri2008]

Thanks for your good tutorial in my case I don't know what is the event itself but I know the date I need to go before it how I can do that

[@mughees52]

you use the options --start-datetime --stop-datetime Please refer to the documentation dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html

[@alaabadri2008]

@@mughees52 I try it but specially when use --stop nothing happens no data return if you have worked example please share it

[@filima-dba]

Sir my database size it 500 GB and I started dump at 1am and it's completed at 4am.
I did not use --master-data=2 or single transaction options.
So I have to apply binary log from 1 am or from 4am.
Please guide sir.

[@mughees52]

don't use mysqldump for backup use percona xtrabackup ..

[@fahdbahoo1]

if backup is taken without using --master-data=2, then how to get MASTER_LOG_FILE and MASTER_LOG_POS ?

[@mughees52]

Read the first 500 line it should be there

[@fahdbahoo1]

@@mughees52 Thanks for replying, i am checking

[@audio3980]

so, how are you goin to use mysqldmp for a 1TB table? you can't! show how you do this with physcial backups please!

[@thiruardura]

if you are using Oracle MySQL then you need to use MySQL Enterprise Backup. Or if you are using Percona then you have to use Xtra backup. This is my understanding. You can't use MySQL dump for large databases.

[@audio3980]

@@thiruardura 2 years later……..🤣