Re: Restore Data from deleted DB in MySql

[Daniel Kasak]

Alex wrote:

Hi

I created DB in MySql with name “xxxxx”

I finish fill data to this DB



Next day somebody run any script

And this script removed my DB and created new DB with the same name



How can I get my data back in MySql
 

Did you have any logging running? Maybe a binary transaction log or 
something? If so, you can run the log through MySQL and recreate what 
happened ( stop the log replay before your database was dropped ).
Check your mysql startup options ( and possibly your my.cnf file ) to 
see if logging is enabled.

--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com.au
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]