Hi guys,

I am a bit of a newbie and I am working with a colleague using a MySQL database. He created a table called x. He emailed me the x.frm file, and I copied it into my data folder in MySQL, but when I try Select * From x in the command prompt I get this error:
Error 1016(HY000): Can't open file ('x.InnoDB') (errno:1)

Executing show tables brings up the x as one of the tables in that database, but why cant I see its contents?

Any help would be appreciated.

Thanks

It's because you just have the table description (frm file) and no data/index file or table space.

You should recreate your table based on the show create table

How do I do that?

You can ask to have the sql script or your can recreate the table using myisamchk