I made a mistake and need help to recover

[epdavis23]

I made a mistake and typed in - instead of = on a delete command and instead of deleting one row, it deleted 34 rows. Anyone have any ideas how to get the rows back. I have mysql 3.23.41 running on Solaris.

 

[rycamor]

Unless you have a backup, or have been running some sort of replication/failover, you are pretty much out of luck, sorry. This is why it always pays to make a dump of the table or the whole database before doing queries like this. -------------------------------------------

"Calculus is just the meaningless manipulation of higher symbols"
                          -unknown F student