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. Oct 2, 2011 at 18:45

2 Answers 2


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.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.