?
Solved

Rollback a dropped database

Posted on 2002-04-05
1
Medium Priority
?
475 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 5

Accepted Solution

by:
kelfink earned 90 total points
ID: 6922025
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

Get real performance insights from real users

Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses

752 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