Bug #55317 Table 'dbname.tablename doesn't exist
Submitted: 16 Jul 2010 11:40 Modified: 16 Jul 2010 11:53
Reporter: Anil Alpati Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.45 OS:Linux
Assigned to: CPU Architecture:Any

[16 Jul 2010 11:40] Anil Alpati
Table 'dbname.tablename doesn't exist

But TABLE Exists.

I am facing this error since I  have stopped mysqlserver and taken database backup from data directory (data folder) 

copied to new system and start the MySQL server in new system

Server Start Sucessfully.But could not able to SELECT the database tables.

Please help me out for fixing this issue.

How to repeat:
Table 'dbname.tablename doesn't exist

All the Database tables are InnoDB Engine type.
[16 Jul 2010 11:47] Anil Alpati
Also I have executed mysqlcheck option. 

Error    : Table 'schemaname.tablename' doesn't exist
status   : Operation failed

This happens for all tables;

please reply at your earliest. thanks in advance
[16 Jul 2010 11:53] Valeriy Kravchuk
We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/

Thank you for your interest in MySQL.