exported mysql database with TMD file? - 07-16-2004 , 07:21 AM
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?
Re: exported mysql database with TMD file? - 07-17-2004 , 12:41 AM
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