MySQL Forums
Forum List  »  Replication

rescue some data out of ibdata1
Posted by: Mathias Saal
Date: January 28, 2005 02:18PM

hi, it's very frustrating! I have a database with two tablespaces. One for developing, the other for some productive storage. While testing I needed to delete all coloms from the tables and did so. effect. So I did it again. What I did not know: my sql-client use the first configured login by default and makes a connection with this login if there is none while executing a statement... so ( you probably know what ) I deleted all data in my producive tablespace!!!!! I already wrote a special tool to backup the data from the database and just wanted to test it in my test-tablespace... so I have nothing... except: ibdata1; ib_logfile0; ib_logfile1 and some other stuff.

Why I think I probably can save some data: because I can read them in the ibdata1 - file!



Options: ReplyQuote

Written By
rescue some data out of ibdata1
January 28, 2005 02:18PM
February 03, 2005 01:21AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.