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?
Tell me more
×
Database Administrators Stack Exchange is a question and answer site for
database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
|
|
||||
|
|
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! vorax |
|||
|
|
|
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. |
|||
|
|
