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.
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 host name',
MASTER_USER='replication user name',
MASTER_PASSWORD='replication password';
and then START SLAVE; and see what
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 ?