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

[Jimmy Guerrero]

Hello,

A default install should drop data and databases into C:\Program
Files\MySQL\MySQL Server 5.0.\data

If you run something like:

mysql> CREATE DATABASE test1;
Query OK, 1 row affected (0.00 sec)

mysql> USE test1;
Database changed

mysql> CREATE TABLE t (i INT) ENGINE = MYISAM;
Query OK, 0 rows affected (0.10 sec)

Then go to C:\Program Files\MySQL\MySQL Server 5.0.\data\test1

Do you see the following in that directory?

T.frm
T.myd
T.myi

The files aren't hidden or anything.

If you are trying to copy a database/tables from one machine to another,
check out:

http://dev.mysql.com/doc/refman/5.0/en/upgrading-to-arch.html

Jimmy Guerrero
Sr Product Manager
MySQL, Inc

> -----Original Message-----
> From: misingo@stripped [mailto:misingo@stripped] 
> Sent: Thursday, September 07, 2006 4:32 PM
> To: mysql@stripped
> Subject: where are the .MYI and .MYD files?
> 
> 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
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 
>