1

mysql table showing in show tables but not accessible

view story
linux-howto

http://serverfault.com – I have a table packages which holds a couple of thousands of rows, there's a mysterious problem with it, it's that I can see it exists from 'show tables' but I when I do 'select ... from packages', mysql says the table doesn't exist. What's wrong? error msg: Cannot find or open table market/ma_package from the internal data dictionary of InnoDB though the .frm file for the table exists. Maybe you have deleted and recreated InnoDB data files but have forgotten to delete the corresponding .frm files of InnoDB tables, or you have moved .frm files to another database? or, the table contains in (HowTos)