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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 07, 2006 4:32 PM > To: mysql@lists.mysql.com > 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/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
