• Post Reply Bookmark Topic Watch Topic
  • New Topic

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

Mike London
Ranch Hand
Posts: 1500
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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.


- mike
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!