Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Upgrading MySQL Issues -- "Table doesn't exist"

 
Mike London
Ranch Hand
Posts: 1290
6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I just installed MySQL 5.6.24 before getting database dumps from the old installation.

What's happening is that on some of the databases, although I'm able to open them, when I try to do a query on the table, I get the error that the table does not exist.

Yet, in the MySQL data directory, there is the table with, in this case, 10 KB. There's also an 'idb" file with close to 2 MB.

The permissions appear to be correct ("_mysql/wheel") and this database had data before the upgrade.

Some DBs are fine after the copy over to the new data folder.

Suggestions would be appreciated.

Thanks,

- mike
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!