MySQL config master-slave times error and handling

1. The error message is as follows:

Last_sql_error:error ' Can ' t drop database ' Oldboy '; Database doesn ' t exist ' on query. Default database: ' Oldboy '. Query: ' Drop database Oldboy '
Replicate_ignore_server_ids:
Master_server_id:1
1 row in Set (0.00 sec)

To resolve the processing process:

mysql> stop Slave;
Query OK, 0 rows affected (0.01 sec)

mysql> Set Global sql_slave_skip_counter = 1;
Query OK, 0 rows Affected (0.00 sec)

mysql> start slave;
Query OK, 0 rows affected (0.01 sec)

At this point, the processing completed, prompted, the production environment will be lost data, use with caution.

2, the error message is as follows

Last_io_error:got fatal Error 1236 from master when reading data from binary log: ' Binlog truncated in the middle of even T Consider out of disk space on master; The first event ' mysql-bin.000001 ' at A, the last event read from '/data/3306/mysql-bin.000001 ' at, the last byte re Ad from '/data/3306/mysql-bin.000001 ' at 619. '

The processing process is as follows

This error is very low, do not mention, has been resolved

This article is from the "it--Brother" blog, please make sure to keep this source http://402753795.blog.51cto.com/10788998/1727399

MySQL config master-slave times error and handling