Solved

Rollback a dropped database

Posted on 2002-04-05
1
438 Views
Last Modified: 2008-03-06
i want to rollback a dropped db in mysql
is there any command??
0
Comment
Question by:soamai_dmeetoo
1 Comment
 
LVL 5

Accepted Solution

by:
kelfink earned 30 total points
Comment Utility
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

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
Creating and Managing Databases with phpMyAdmin in cPanel.
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now