MySQL Bugs: #26885: Setting up MySQL. copying old DBs: some missing tables? ("table doesn't exist")

Bug #26885	Setting up MySQL. copying old DBs: some missing tables? ("table doesn't exist")
Submitted:	6 Mar 2007 17:20	Modified:	6 Mar 2007 18:00
Reporter:	[ name withheld ]	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	[ S: 5.0.27 ][ C: 5.1.11 ][A: 1.2.10 ]	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any
Tags:	administrator, engine, install, UPDATE

Description:
Hello-

I installed the above-mentioned MySQL 5.0.27 Server (5.1.11 Client) and added the MySQL Administrator 1.2.10 ontop, on a WinXP system (SP2).

Then I copied the folders / directories that I still had from an older install to the new Data folder (in my case "C:\MySQL Datafiles")

They all show up under "Catalogs" (in the Administrator) but some of them have the message "Table 'db_name.table_name' doesn't exist" in the "Engine" column.

I already gathered from a different bug report that this seems to be a problem (possibly due to something I did wrong- or in the wrong order) with InnoDB tables (surely enough, all the tables that *do* show up and are accessible- via the MySQL Query Browser for example- say "MyISAM" in the "Engine"-Column).

Meaning: the tables that *don't* show up still exist, nevertheless, as files in the folder... but only with the *.frm filetye-ending (possibly InnoDB) --- The ones that *do* show up also exist with the "*.MYI" and "*.MYD" ending (MyISAM).

How to repeat:
Blindly copy and paste DB-Folders from an old installation into the DB-Folder of a new Installation, like I did... =(

Suggested fix:
What can I do to fix this- to make the DB Tables viewable? after all, the files *do* exist, I just can't access them (when I try to edit one of those "nonexisting" tables it gives me a "cannot fetch table information").

Thanks in advance! =)

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.