Re: Error reading packet from server: binlog truncated in the middle of event ( server_errno=1236)

[Denis Bucher]

In fact I am note quite sure that LOAD DATA FROM MASTER really worked.

Because if I try to do it again I get :

ERROR 1188 (HY000): Error from master: 'SELECT command denied to user 'repl_slave'@'212-197-17-341.fix.'

("212-197-17-341.fix." being a part (?) of the hostname, 212-197-17-341.fix.provider.ch)

Of course I tried all GRANTs I could without success :

GRANT SUPER, REPLICATION SLAVE, RELOAD ON *.* TO repl_slave@'212-197-17-341.fix.' IDENTIFIED BY '********';
GRANT SUPER, REPLICATION SLAVE, RELOAD ON *.* TO repl_slave@'%' IDENTIFIED BY '********';

Any help will be greatly appreciated !

Denis