Solved

Rollback a dropped database

Posted on 2002-04-05
1
454 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
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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Introduction In this installment of my SQL tidbits, I will be looking at parsing Extensible Markup Language (XML) directly passed as string parameters to MySQL 5.1.5 or higher. These would be instances where LOAD_FILE (http://dev.mysql.com/doc/refm…
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

810 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