Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Mike London
Ranch Hand
Posts: 1227
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic