List:General Discussion« Previous MessageNext Message »
From:misingo Date:September 7 2006 11:32pm
Subject:where are the .MYI and .MYD files?
View as plain text  
I've installed MySQL, created a database and tables and then loaded fields
into them. I use the command line client and can see the fields, use the
select command and every thing is OK, but when I look for the table files
in the data directory, only the .frm ones appear, not the .MYI or MYD.
Where could they be?.
I've copied the data files in a flash memory and tried to see the tables
fields in another computer with the same server version and platform and
get the "db_name.tb_name table doesn't exist" error message. However when
I run the show tables command, the command line shows me the list of the
tables...
In summary, I only can work with my database meanwhile don't restart Windows.

Can anybody help me?

Thanks in advance.

MySQL server version: 5.0.19-nt
Microsoft Windows Xp Professional version 2002 SP2.

Misingo
Thread
where are the .MYI and .MYD files?misingo7 Sep
  • RE: where are the .MYI and .MYD files?Jimmy Guerrero7 Sep
    • RE: where are the .MYI and .MYD files?misingo10 Sep
  • Re: where are the .MYI and .MYD files?Paul DuBois8 Sep
    • RE: where are the .MYI and .MYD files?Fred Ballard8 Sep