recover mysql deleted rows

[kkshansid]

I am working on localhost LAN network
Accidentally deleted selected rows from mysql table
i wanted to execute
select * from mytable where remark='C'
but accidentally executed
delete from mytable where remark='C'
because my previous command was delete command

all my updated records got deleted
Please help if there is any method to recover this data

delete is DML command
I read that it could be recovered
in foxpro no deleted data is permanently deleted
until we use pack command
we can also recover deleted data by
recall all command before pack any time
please help if any equivalent method for the same in mysql
i am using xampp on windows8

[RonB]

There is no "undelete" function.

You need to restore the data from your backup.

Do you have a backup of the data?

[kkshansid]

no backup.
what about bin or mysqldump or .ibd file
sql also has rollback which recovers all

[RonB]

mysqldump is used to create the backup (which you said you don't have) and should be run daily as a cron job.

Doing a rollback only works if you are inside a transaction and didn't execute a commit.

[kkshansid]

i think there should be permanent solution to this problem.
i was of luck that it was simple data entry with 4 data entry operators within company and i re entered them as i had hard copy data of same.
what if it happened to a real time dynamic server hosted data?
from where we could recover data?
its almost impossible to take backup every minute.

[RonB]

That's where a combination of backups and the binlog come in. You first restore from the backup then use the binlog files to "replay" each action from there upto but not including the point where the deletion occurred.

Point-in-Time (Incremental) Recovery Using the Binary Log