• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Bear Bibeault
  • Junilu Lacar
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • salvin francis
  • Frits Walraven
Bartenders:
  • Scott Selikoff
  • Piet Souris
  • Carey Brown

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

 
Bartender
Posts: 1757
17
  • 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
 
Whip out those weird instruments of science and probe away! I think it's a tiny ad:
Building a Better World in your Backyard by Paul Wheaton and Shawn Klassen-Koop
https://coderanch.com/wiki/718759/books/Building-World-Backyard-Paul-Wheaton
    Bookmark Topic Watch Topic
  • New Topic