Hi!!
Each MyISAM table is stored on disk in three files. The files have names that begin with the table name and have an extension to indicate the file type. An `.frm' file stores the table definition. The data file has an `.MYD' (MYData) extension. The index file has an `.MYI' (MYIndex) extension.
You can check there locations(commands will be same on any OS)..
C:\mysql\bin>mysql -uroot -p
Enter password: *******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 238 to server version: 4.0.18-nt
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
(root@localhost) [(none)]> SHOW VARIABLES LIKE '%DATADIR%';
+---------------+----------------+
| Variable_name | Value |
+---------------+----------------+
| datadir | C:\mysql\data\ |
+---------------+----------------+
1 row in set (0.00 sec)
(root@localhost) [(none)]>
All files will be stored in C:\mysql\data\DATABASENAME
You should not edit these(any) files directly..this may cause severe problems..you can connect the server & make use of SQL commands to get required info..
Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221