exported mysql database with TMD file?

[Steve]

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

[steve]

"Steve" wrote:

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!

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

[steve]

"Steve" wrote:

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!

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