Recover MySQL database from data folder without ibdata1

Asked Jan 09 '14 at 11:53

Active Jan 20 '14 at 08:00

Viewed 937 times

My WAMP directory accidentally get deleted by another user. Only data folder in MySQLis available. And, in that only database-folders (folders in "\bin\mysql\mysql5.6.12\data\" with name of databases) are available. Other files including "ibdata1" in root of "\bin\mysql\mysql5.6.12\data\" are also deleted.

The database folder contains files with below extensions

*.frm, *.ibd

and "db.opt" file.

How the databases can be recovered?

edited Jan 20 '14 at 08:00

asked Jan 09 '14 at 11:53

cyberwani

Try using file recovery software – Jan 09 '14 at 19:38
I tried to recover bdata1. But, unable to get it back. – cyberwani Jan 10 '14 at 09:18
Are you trying to recover MYISAM databases or INNODB? – RiggsFolly Jan 10 '14 at 11:39
Both MYISAM and INNODB. – cyberwani Jan 10 '14 at 12:32
I am **still waiting** for any support/reply which can help me to recover my @MySQL data. – cyberwani Jan 20 '14 at 07:36
I get my solution from here : http://dba.stackexchange.com/questions/57120/recover-mysql-database-from-data-folder-without-ibdata1-from-ibd-files – cyberwani Jan 25 '14 at 04:50

Recover MySQL database from data folder without ibdata1

0 Answers0