Re: Slave to host connection

2001-04-10 Thread MCA Department PESIT
>They are both running the latest version? > >Running out of ideas. > >MCA Department PESIT wrote: > > > > Hi, > >i have edited the host file but still the error message is the same. > > There seems to be no problem in connecting the master to slave, but vi

Re: Slave to host connection

2001-04-10 Thread MCA Department PESIT
92.168.1.2' (111) Mathew At 09:07 AM 4/9/01 -0500, you wrote: >To eliminate DNS problems, put each machine in the others /etc/hosts >file. > >MCA Department PESIT wrote: > > > > Hi there, > >the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes,

Slave to host connection

2001-04-09 Thread MCA Department PESIT
Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me

Slave to host connection

2001-04-08 Thread MCA Department PESIT
Hi there, the master is running on 192.168.1.2 and the slave on 192.168.1.5 , yes, the master is running. the user name and password are correct. actually i dont think it gets to the state of actually verifying the user name and password. even if i do just a mysql -h 192.168.1.2 it gives me

Slave to Master Connection

2001-04-08 Thread MCA Department PESIT
Hi there, the error that i specifically get when the slave tries to connect to the master is 010409 10:44:58 Slave thread: error connecting to master:Can't connect to MySQL server on '192.168.1.2' (111)(107), retry in 60 sec even if i try to run mysql -h master the same error happens.

Cannot Connect to remote host for replication

2001-04-08 Thread MCA Department PESIT
hi there, i have been trying to implement replication, however the error that i get is ERROR 2003: Can't connect to MySQL server on '192.168.1.2' (111) i try to do this at the linux prompt at the slave with mysql-h hostname and the same error is displayed. what could be wrong ?? thanks in

my.cnf problems

2001-04-04 Thread MCA Department PESIT
hi there, my data directory is /var/lib/mysql . i have created a .my.cnf file here. i have restarted mysql and now i am not sure whether the entries are being read from the cnf file. can you tell me how to confirm this ?? thanks in advance bye Mathew -

Calculated Fields

2001-04-04 Thread MCA Department PESIT
Hi there, i have a similar query regarding calculated fields. i have a table which stores the 3 test results in a particular subject. i need to find the average of the best 2 of the tests, i.e for a entry of 46,47,48 i need to find average of 47 and 48. as of right now i am using a field to