Re: where are the .MYI and .MYD files?

[Paul DuBois]

misingo@stripped wrote:
> 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?.

If you see the .frm files but no .MYI/.MYD files, that suggests that 
your tables are not MyISAM tables. Try "SHOW CREATE TABLE tbl_name" for 
some value of tbl_name. Look for the ENGINE = option near the end of the 
statement.  Perhaps when you installed MySQL, you selected InnoDB as the 
default table type.


> 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...

I believe SHOW TABLES only needs to see a .frm file to believe that a 
table exists.