Recover INNODB tables without ibdata1 ?

M

majdi33

Verified User
Joined
Oct 29, 2011
Messages
34
Hello,

Is it possible to recover innodb tables from .frm files and without ib* files ?
 
majdi33 said:
i recovered the lost ibdata1
Click to expand...

Mind sharing how you did that?

I'm always a little amused that someone will learn how to fix something, but not share how they did it. Odds are high someone will Google search this thread and be completely needing your solution. It would be helpful if you explained things a little more in details for others.
 
I found a backup of ibdata1 and I put it back where it is suposed to be /home/mysql
i hope this is very helpful for the googelers whi will find this topic.
 
Hi,
InnoDB is a storage engine which provides safe transaction database in MySQL. But the database is prone to corruption many times and it becomes very important to prevent the database so that the data stored in it cannot gets damaged. But no need to worry when anything such happens because there are ways to restore the data and to fix the database.
See more on: http://www.filerepairtool.net/blog/recovering-crashed-corrupted-innodb-database
 
You must log in or register to reply here.
Back
Top