Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2004
    Posts
    2

    Unanswered: Using MyQL tables with my MySQL

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    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
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Dec 2004
    Posts
    2

    Recreating a table

    How do I do that?

  4. #4
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    You can ask to have the sql script or your can recreate the table using myisamchk
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •