How To Recover A Dropped MySQL Database From The Binary Logs

00:04:10 Showing the test site of the database.
00:05:10 Make sure your binlogs are enabled.
00:06:10 Time to drop the database.
00:08:10 Explanation of the magic restoration command.
00:11:05 Examining the logs to get the drop time.
00:13:55 Running the command.
00:14:55 Adding the missing data back to the database.
00:18:50 The restore has finished, so lets look if the site is back.

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.

To find the command you will have to look on my website, because Youtube would not allow it:

[johnmichael]

Thank you very much! you literally saved my life!