WampServer

Deleted some records from a table in my database. And I tried to search the internet, and saw on the binary files found in the / wamp/bin/mysql/mysql5.5.24/data.
The names:
mysql-bin.000001
mysql-bin.000002
.....
mysql-bin.000011
mysql-bin.000012


I tried using the command below, but failed. No warning message appears. As shown at the bottom of the image page.

mysqlbinlog mysql-bin.000001> C:/binlog
or
mysqlbinlog mysql-bin.000001> C:/binlog.txt
or
mysqlbinlog mysql-bin.000001> C:/binlog.sql


the image: [img266.imageshack.us]

help me!! i need :/

mysqlbinlog is an executable ( .exe ). It lives in c:\wamp\bin\mysql\mysql5.x.y\bin

You run it from a command line and not from within the mysql console.

see

http://dev.mysql.com/doc/refman/5.5/en/mysqlbinlog.html

But when I open, it closes automatically.

open CMD

navigate to the folder and type in the name of the exe

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

My operating system is installed on drive C. The wampserver is installed on the D drive. is not possible to open the CMD unit D.

OMG its not possible? maybe you should call Bill Gates and let him know of his stupid mistake?!!

or maybe you shouldn't be using a pc ....


OPEN CMD

TYPE

d: (press enter)



TYPE

cd wamp\bin\mysql\mysql5.5.24\bin (press enter)

TYPE

mysqlbinlog mysql-bin.000001> C:/binlog.txt


And in future, try using Google, its a search engine that has all these results when you type in keywords...

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 3 time(s). Last edit at 01/25/2013 10:50PM by stevenmartin99.

Oh thank you so much, i know i am an idiot when it comes to PC's and im also really lazy



Edited 1 time(s). Last edit at 01/26/2013 07:06PM by stevenmartin99.