Possible? Restore tables from ib_logfile1, no binary logs
Posted by:
Miltos P
Date: October 27, 2012 06:54AM
Hi there,
i recently started using MySql by installing XAMPP for Windows. I was doing some tests and then started creating a few tables. I accidentally dropped the database and then i realized that i never took a backup and nor i had an sql script to create the schema. Can anyone please help me?
I only have the logfiles in data directory (i use windows) ib_logfile0, ib_logfile1 and ibdata1 files. No .frm files exist.
I use Xampp with the following versions:
###### ApacheFriends XAMPP (Basispaket) version 1.7.4 ######
+ Apache 2.2.17
+ MySQL 5.5.8 (Community Server)
Unofrtuantely, xampp doesnt have the binary log enabled by default...
Is there any chance i get my schema back? I didn't have any data.
Thanks!
Edited 1 time(s). Last edit at 10/27/2012 09:05AM by Miltos P.
Subject
Views
Written By
Posted
Possible? Restore tables from ib_logfile1, no binary logs
2254
October 27, 2012 06:54AM
819
October 29, 2012 09:14AM
1138
October 31, 2012 06:35AM
880
November 01, 2012 10:59PM
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.