How To Recover A Dropped MySQL Database From The Binary Logs
In this video I am showing how to recover a dropped database, from the binlog files of a MySQL setup. The reason I am doing this video is because I had a situation when I had to do this very thing and I tried looking up on the internet how to do this, but I was having a hard time finding anyone who had gone through the whole process, so I ended up having to manually read through the documentation, in order to see how it could be done. The process turned out to be quite straightforward, so I thought it would be worth doing a video showing how to do it.
mysqlbinlog -d dbname --stop-datetime="2020-01-23 15:04:55" mysql-bin.0000?? > dbname-binlog.sql