exported mysql database with TMD file?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Steve
    #1

    exported mysql database with TMD file?

    Hi. I've got an exported database from an external system. It's in the
    format of MYI, MYD and frm extension files. However, one table in this
    database has book.frm, book.MYD, book.MYI _AND_ book.TMD.

    When I've created a database in phpmyadmin/mysql, moved all the files
    into the proper directory, every table can be looked at and selected
    but this book table states that it's in use. When I try to browse it,
    it states that the book.MYI cant be opened!

    any ideas anyone please?

    ta

    Steve
    Tags: None
    • steve
      #2
      Re: exported mysql database with TMD file?

      "Steve" wrote:[color=blue]
      > Hi. I’ve got an exported database from an external system.
      > It’s in the
      > format of MYI, MYD and frm extension files. However, one table in[/color]
      this[color=blue]
      > database has book.frm, book.MYD, book.MYI _AND_ book.TMD.
      >
      > When I’ve created a database in phpmyadmin/mysql, moved all the
      > files
      > into the proper directory, every table can be looked at and[/color]
      selected[color=blue]
      > but this book table states that it’s in use. When I try to
      > browse it,
      > it states that the book.MYI cant be opened!
      >[/color]

      Steve, when you move data to a new database, you usually have to
      repair all the imported tables. Run a sql repair on each table at a
      time, and this should hopefully fix your problem.

      --
      http://www.dbForumz.com/ This article was posted by author's request
      Articles individually checked for conformance to usenet standards
      Topic URL: http://www.dbForumz.com/mySQL-export...ict130106.html
      Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=435005

        Comment

        • steve
          #3
          Re: exported mysql database with TMD file?

          "Steve" wrote:[color=blue]
          > Hi. I’ve got an exported database from an external system.
          > It’s in the
          > format of MYI, MYD and frm extension files. However, one table in[/color]
          this[color=blue]
          > database has book.frm, book.MYD, book.MYI _AND_ book.TMD.
          >
          > When I’ve created a database in phpmyadmin/mysql, moved all the
          > files
          > into the proper directory, every table can be looked at and[/color]
          selected[color=blue]
          > but this book table states that it’s in use. When I try to
          > browse it,
          > it states that the book.MYI cant be opened!
          >[/color]

          Steve, when you move data to a new database, you usually have to
          repair all the imported tables. Run a sql repair on each table at a
          time, and this should hopefully fix your problem.

          --
          http://www.dbForumz.com/ This article was posted by author's request
          Articles individually checked for conformance to usenet standards
          Topic URL: http://www.dbForumz.com/mySQL-export...ict130106.html
          Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=435005

            Comment

            Previous template Next
            Working...