There are some rows in a table, by mistakenly I had deleted all rows from the table and data got commited. So is there any way to restore data for that table.
I am not having backup of the database.
I did not enable Binary Logging.
If you had replication (or binary logging) enabled (
If you have some backup (and recorded binary log position from time of backup), you need recover a backup and then replay logs from position, when backup was taken.
If you don't have a backup, then NO. The data is lost.
I suggest you learn about the