I was planning to drop all the tables from a test account, but unfortunately, I didn't notice that I was in the production account when I chose to drop all the tables of my db from phpmyadmin interface.
Is there any way of recovering my db content?
-
If you don't have a backup, not really.– Derek DowneyCommented Oct 2, 2011 at 18:45
Add a comment
|
2 Answers
Sorry, that you had such an accident.
If you have binary logs on, you could try the recovery options described here: Point in time recovery
Another thing is to restore a backup, hopefully, you have one. Changes made after this, could be restored as mentioned above.
Good luck!
If you have a current backup restore from that backup.
If you don't you have just learned why you need to setup backups on your production servers.
Sorry.
