Bhartendu Maheshwari <[EMAIL PROTECTED]> wrote on 06/12/2003
14:40:29:
> I know at the time of table creation mysql creates 3 file .frm, .MYD,
> .MYI and is stored in the path given by --datadir=****, I want to know
> when I call insert row then where is this data goes I mean in which file
> it stores. I want to shared the database files but when I do this it
> shares only the table definition not the table data, shows tables are
> empty. So can anyone please help in sharing the table data.
The table definition is in the .frm file, the raw table data in the .MYD
file and the indexes in the .MYI file.
HOWEVER, it is very dangerous to share these files. MySQL performs
extensive internal caching, so that it is rarely possible to know when
these files are up-to-date while mysqld is running. Sharing the data files,
rather than sharing the mysqld server, is not to be recommended at all.
Could you perhaps explain what you are trying to achieve? There is quite
likely to be a better way to achieve it.
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
