1

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

ObbieWan
  • 13
  • 3

1 Answers1

0

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

Bill Karwin
  • 538,548
  • 86
  • 673
  • 828
  • Just did that, with the same result. Running MySQLServer 8.0.26 on a windows machine and it just won't do anything with the mysqlbinlog – ObbieWan Jan 26 '23 at 16:49
  • Your screenshot clearly shows that you're trying to run the command in the MySQL client. If you got the same result, then you're still trying to run the command in that client. You need to open a command window. – Bill Karwin Jan 26 '23 at 17:00
  • I've used MySQL command line client, MySQL Shell, and the Windows Command Line with the same result on all 3. – ObbieWan Jan 26 '23 at 17:16
  • Well, I've now realized how dense I was being thanks to a nice long break. Finally got mysqlbinlog to work, now to try and use it. Thank you Bill for your help, even though I wasn't able to grasp what you were telling me right away haha. – ObbieWan Jan 26 '23 at 20:38