MySQL Forums
Forum List  »  InnoDB

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Possible? Restore tables from ib_logfile1, no binary logs
2254
October 27, 2012 06:54AM


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.