whoa! problems.. problems..problems.. mysql replication system down.. looks like the slave data did not replicate from the master. The slave do not know what point in which binlog to start so i have to fix it by hand..what i do is :-
On Master
mysql> show master status;
write down master log file name and current positions. lets say the master file is server-bin-007 and the positions on 111000 . On slave now we must tell the slave server to read the current file and positions.
On Slave
mysql> slave stop;
mysql> change master to master_log_file='server-bin-007', master_log_pos=111000;
mysql> start slave;
confirm that I/O is running with
mysql> show slave status\G;
now the slave knows which point to start..
i'm a broken man splitted into pieces like a cheese thats why i'm using poor and broken english.
