Rollback a dropped database

i want to rollback a dropped db in mysql
is there any command??
soamai_dmeetooAsked:
Who is Participating?
 
kelfinkCommented:
Oops! Given that mysql's default behavior (with ISAM and myISAM tables) doesn't even support rollback for insert/update/delete, no.  

And, in general, the DROP ... commands in SQL (data definition statements) aren't transactional, and cannot be rolled back.

To see if your data is truly gone, locate your data directory... on NT it's generally located in the mysql\data directory.  Unix, probably similar... /home/mysql/data...

Look for a subdirectory with the name of your database.  If it's not there, time to pull some backup tapes. Fingers crossed!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.