1

I reinstalled WAMP Server today, the same version I've used to create several databases. All my database data is still present in the original wamp/bin/mysql/mysql5.6.12/data files. All the .frm and .ibd files are present.

What do I need to do to recover these tables?

I've already checked file permissions, modified the innodb_force_recovery variable and created a new mysql-bin.index file.

Giacomo1968
  • 25,759
  • 11
  • 71
  • 103
Brandon Buster
  • 77
  • 2
  • 10
  • check the mysql directory path in your environment – Yehia Awad Jul 05 '14 at 04:34
  • This question might better be asked on **dba.stackexchange.com**. – spencer7593 Jul 05 '14 at 04:44
  • possible duplicate of [Where does WAMP server store database files](http://stackoverflow.com/questions/5515403/where-does-wamp-server-store-database-files) – a coder Jul 05 '14 at 05:06
  • This isn't a path question. I know where all my files are and so does MySQL. It sees all my databases and it's aware of all my MYISAM tables. It's only the InnoDB tables that MySQL is not reading. – Brandon Buster Jul 05 '14 at 12:14
  • what exactly do you mean by "Not Showing"? Can you see the tables in SHOW TABLES output? Is the original ibdata1 is still present? – akuzminsky Jul 05 '14 at 15:24

0 Answers0