Running MySQL Daemons with same data files

2003-12-09 Thread Bhartendu Maheshwari
Dear All, I am working in Linux 8.0 and running mysql 4.0.16. I am trying to access same data files from the two mysql daemons. I mean there are two PC's running with mysql and one NAS server where data files are kept. To run mysql on the machines I first mount the NAS file system and then run it

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

2003-12-07 Thread Bhartendu Maheshwari
wrote: > > > > > > > > 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 > &g

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

2003-12-07 Thread Bhartendu Maheshwari
s properly, nothing in buffers and cache. How can we do that, I tried with --flush but its not helping much, is there any good options? regards bhartendu On Sat, 2003-12-06 at 20:15, [EMAIL PROTECTED] wrote: > > > > > > > > Bhartendu Maheshwari <[EMAIL PROTECT

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 whe

Re : Problem in initializing mySQL on Windows Plateform

2001-06-29 Thread Bhartendu Maheshwari
From: Bhartendu Maheshwari Date: Saturday, June 30, 2001 07:21:08 AM To: [EMAIL PROTECTED] Subject: Re: Problem in initializing mySQL on Windows Plateform   Thanx for yr help

Problem in initializing mySQL on Windows Plateform

2001-06-28 Thread Bhartendu Maheshwari
Hello I had installing mySQL as well myODBC, but when I run mysqld it has given an error C:\>mysqld error: Found option without preceding group in config file: c:\my.cnf at line: 1 Program aborted Next time I had write a file my.cnf as innodb_data_file_path = ibdata1:400M;ibdata2:40