- 论坛徽章:
- 0
|
10可用积分
主机A配置:
server-id = 1
log-bin
set-variable=binlog-ignore-db=mysql
B机配置:
server-id = 2
master-host =192.168.0.10
master-user = rep
master-password = rep
master-port = 3306
set-variable=replicate-ignore-db=mysql
set-variable=replicate-do-db=tianlinfengjing
set-variable=replicate-do-db=bb
我在B机上用 SHOW SLAVE STATUS\G的时候报错!
请那个高手帮我看看!
mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 192.168.0.10
Master_User: rep
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.000030
Read_Master_Log_Pos: 98
Relay_Log_File: web02-relay-bin.000020
Relay_Log_Pos: 16556424
Relay_Master_Log_File: mysql-bin.000019
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB: bb,tianlinfengjing
Replicate_Ignore_DB: mysql
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1007
Last_Error: Error 'Can't create database 'tianlinfengjing'; dat
abase exists' on query. Default database: 'tianlinfengjing'. Query: 'CREATE DATA
BASE `tianlinfengjing`'
Skip_Counter: 0
Exec_Master_Log_Pos: 16556287
Relay_Log_Space: 2360772369
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
1 row in set (0.00 sec)
-----------------------------------------------------------
下同面是日志错
081202 23:19:36 [ERROR] Slave: Error 'Can't create database 'tianlinfengjing'; database exists' on query. Default database: 'tianlinfengjing'. Query: 'CREATE DATABASE `tianlinfengjing`', Error_code: 1007
081202 23:19:36 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000019' position 16556287
081202 23:19:36 [Note] Slave I/O thread: connected to master 'rep@192.168.0.10:3306', replication started in log 'mysql-bin.000030' at position 98 |
|