Maybe you should check if the ip address resolved for the
master's url is correct ?
Also try using CHANGE MASTER TO
MASTER_HOST='',
MASTER_USER='',
MASTER_PASSWORD='';
and then START SLAVE; and see what happens.
regards Jurgen
> Tried that, but no luck, they get r
You need to shutdown mysql, delete the master.info and
relay-log.info files and then start mysql again.
The reason for this is because if the info files are
present then mysql uses them as is and only recreates them
from my.ini or my.cnf if absent.
This should get your replication going again.
re
Say I have the following table (TBL):
KEY GRP VAL
1 A 2
2 A 3
3 A 1
4 B 2
5 B 1
6 B 3
"select KEY, max(VAL) from TBL group by GRP" gives:
KEY max(VAL)
1 3
4 3
the desired result though is:
KEY max(VAL)
2 3
6 3
any ideas on how to achieve this ?
Apparent
