post recovery error - table does not exist

[Dave Phillips]

Hi all,

I have spent hours on this and am at my wits end. Thankfully, due to many posts I have gotten as far as I am. Here's the story:

My windows installation got corrupted and I had to install a fresh copy. As a result, I was not able to dump my tables and data from my original mySql (5.5) installation. However, my drive was NOT corrupted, so I did have access to the original database files from the mySQL data directory.

I have gone through the recovery process and gotten as far as being able to start my new MySQL installation and I can actually SEE all of my DB schemas from my original installation. I had copied these over manually following instructions on many of the links provided on this and other sites.

So here's what happens: If I try to SELECT anything from these schemas, I get an error saying "Table 'whatever' does not exist'. However, I can obviously see that it odes exist. I can change to the schema either through the workbench or by using 'use schema_name' from the command prompt. However, after doing that I still cannot select anything from the tables.

I have tried updated the password in the mysql.user table but that didn't help. The passwords for root user for both installations were the same.

If someone can point me in the next direction, I would appreciate it. FYI, it is a Windows installation.

Thank you!

Dave