On Jul 25, 2011, at 12:08 PM, Adarsh Sharma wrote:
> I restore globedatabase from a .sql file on yesterday morning.I insert some new data in that database.
> In the evening, by mistake I issued a drop database globedatabase command.
> Today morning, I restore again the same database from backup (.sql) file.
> My .sql file have data till yesterday morning but I want newly insert data now. Is it possible.
> Is it possible to get the data back till the state before drop database command.
No you won't be able to recover.
If you have Online Backup, then PITR would help you.
Thanks & Regards,
Vibhor Kumar
Blogs: http://vibhork.blogspot.com
http://vibhorkumar.wordpress.com