mysqlrecoverypitr

How do I use MySQL Binlog for PITR


I am attempting to recover lost data using mysqlbinlog. Admittedly I am far from an expert in using MySQL, and even farther when using command line, so any advise would be very very welcome. I've seen so many docs that say what to do to view the binlogs, but it does not work at all on my machine. What am I doing wrong here?

This is exactly what happens every time

I've tried running this multiple times. I've also tried listing out the path to the binlog file in that Data folder.

Update: Same thing happens when using MySQL Shell


Solution

  • Run the mysqlbinlog command at a shell prompt, not in the MySQL client.