mysql数据同频的时候出错!请高手指点一下

leidong8

主机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

kns1024wh

你的bin-log是否是以行进行复制的

vermouth

Error 'Can't create database 'tianlinfengjing'; database exists' on query. Default database: 'tianlinfengjing'. Query: 'CREATE DATABASE `tianlinfengjing`'
没看懂么？手动创建喽~

luo118

stop slave;
load data from master;
start slave;
show slave status\G #再看看