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?
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.