Hi I have setup a mysql replication Master-slave using mysql utilities, my master have went down as the disk space of log file was full, then I chan ged the log file and started master now slave have stopped giving the error master disk full.
Now when I am trying to start mysql replication, it giving the following output. Please help me resolving this.
sudo mysqlreplicate --master=user:password@IPaddress:3306 --slave=user:password@IPaddress:3306 --rpl-user=user:password WARNING: Using a password on the command line interface can be insecure. # master on 10.0.0.1: ... connected. # slave on 10.0.0.2: ... connected. # Checking for binary logging on master... # Setting up replication... ERROR: failed to sync slave with master. ERROR: Cannot setup replication.
This is the error in show slave status\G;
Last_IO_Errno: 1236 Last_IO_Error: Got fatal error 1236 from master when reading data from binary log: 'binlog truncated in the middle of event; consider out of disk space on master; the first event 'mysql-bin.000012' at 70361002, the last event read from '/app2/mysql/mysql-bin.000012' at 70361002, the last byte read from '/app2/mysql/mysql-bin.000012' at 70361088.' –