Nasser Heidari

2010-10-11

MySQL fatal error 1236

Filed under: Linux — Nasser Heidari @ 17:09

DB-1:

mysql> show master status;

File Position Binlog_Do_DB Binlog_Ignore_DB
bin.007733 824963644

DB-2:

mysql> STOP SLAVE;
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)

mysql> UNLOCK TABLES;
Query OK, 0 rows affected (0.00 sec)

mysql> CHANGE MASTER TO
MASTER_HOST=’DB-1′,
MASTER_USER=’replication’,
MASTER_LOG_FILE=’bin.007733′,
MASTER_LOG_POS=824963644;
Query OK, 0 rows affected (0.00 sec)

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

http://www.dougreese.com/mysql-fatal-error-1236.html

Advertisements