Re: How can I share the MySQL data and where data and index files are stored

2003-12-07 Thread Bhartendu Maheshwari
Dear Alec Thanks for the quick response. I am doing some work in High Availabilty. We have two real servers(just 2 PC's) and we want the both PC to run MySQL but uses one common database data file. We have one NAS server, we will keep all the data file there and mount it on local system and try

Re: How can I share the MySQL data and where data and index files are stored

2003-12-07 Thread Alec . Cawley
Bhartendu Maheshwari [EMAIL PROTECTED] wrote on 07/12/2003 07:56:26: I am doing some work in High Availabilty. We have two real servers(just 2 PC's) and we want the both PC to run MySQL but uses one common database data file. We have one NAS server, we will keep all the data file

Re: How can I share the MySQL data and where data and index files are stored

2003-12-07 Thread Bhartendu Maheshwari
I accepted the performance issue but I don't want two separate copies of data, I only want on every SQL command the MySQL daemon reads/writes from/in the file. How can I force MySQL daemon to do the same? regards bhartendu On Sun, 2003-12-07 at 18:51, [EMAIL PROTECTED] wrote:

How can I share the MySQL data and where data and index files are stored

2003-12-06 Thread Bhartendu Maheshwari
Dear All, I am working on linux 8.0 and mysql 4.0.18. I want to know where the mysql stores the data files and index files? 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

Re: How can I share the MySQL data and where data and index files are stored

2003-12-06 Thread Alec . Cawley
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