Hi, I would like to know the following. Can some one tell me? 1. Where are the actual files for the mysql databases/tables are stored? I assume this is the /data directory under the mysql installation directory, but not sure. 2. how to create a mysql database in a specific file system. Thanks in advance, Balaji.

1. mysql stores the data in a location you specify on install - by default, it goes in \data within the mysql folder. Each folder relates to a database, but the "raw data" is stored in different locations depending on the ENGINE you use for your tables. For innoDB tables, data sits in the ibdata file in the root data directory. For MyISAM, tables, data sits in the database folder. *.MYD is data, *.MYI are indexes, *.frm are table definitions (I think) 2. Not 100% sure what you mean by this but it happens when you issue the CREATE TABLE statement. CREATE TABLE t1 (field INT NOT NULL PRIMARY KEY) ENGINE=MYISAM; HTH