By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,666 Members | 1,784 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,666 IT Pros & Developers. It's quick & easy.

exported mysql database with TMD file?

P: n/a
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
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Jul 20 '05 #2

P: n/a
"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
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.