Sample Header Ad - 728x90

Recover MySQL database from data folder without ibdata1 from ibd files

17 votes
1 answer
65053 views
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. **All files** including "**ibdata1**" in root of "\bin\mysql\mysql5.6.12\data\" are also deleted. The database folders contains files with below extensions only. *.frm, *.ibd and "db.opt" file. How the databases can be recovered? I already have tried to recover bdata1. But, unable to get it back. And, some database contains MYISAM also.
Asked by cyberwani (173 rep)
Jan 20, 2014, 10:00 AM
Last activity: Feb 22, 2017, 11:24 PM