Bonjour à tous,

je cherche à mettre en place une réplication sous mysql 6 sur deux serveurs maitre/esclave sous XP.
les fichier de conf my.ini semblent correctement édites sur chacune des machine.

Cependant quand je crée une nouvelle base ou une nouvelle table sur mon serveur maitre, il ne se passe rien sur le serveur esclave.

Ci-après les sorties concernant les status des deux serveurs.

Avez vous une idée sur ce qui pourrait poser problème et une solution, un paramètre à indiquer en plus?? J'ai suivi plusieurs tutos bien expliqués, a priori j'ai indiqué le minimum d'info dans les conf.



Je vous remercie par avance pour votre aide.



mysql> show master status;
+-------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+-------------------+----------+--------------+------------------+
|master-bin.000001 | 365506 | | |
+-------------------+----------+--------------+------------------+
1 row in set (0.00 sec)


mysql> select now(); show processlist \G
+---------------------+
| now() |
+---------------------+
| 2011-08-04 16:58:37 |
+---------------------+
1 row in set (0.00 sec)

*************************** 1. row ***************************
Id: 70
User: root
Host: 10.72.x.x:3095
db: NULL
Command: Query
Time: 0
State: Waiting on cond
Info: show processlist
*************************** 2. row ***************************
Id: 72
User: replication
Host: 10.72.x.x:3159
db: NULL
Command: Binlog Dump
Time: 228
State: Master has sent all binlog to slave; waiting for binlog to be updated
Info: NULL
2 rows in set (0.00 sec)
mysql> select now();show processlist \G
+---------------------+
| now() |
+---------------------+
| 2011-08-04 16:58:34 |
+---------------------+
1 row in set (0.00 sec)

*************************** 1. row ***************************
Id: 3
User: root
Host: localhost:3157
db: NULL
Command: Query
Time: 0
State: NULL
Info: show processlist
*************************** 2. row ***************************
Id: 4
User: system user
Host:
db: NULL
Command: Connect
Time: 225
State: Waiting for master to send event
Info: NULL
2 rows in set (0.00 sec)
mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.72.y.y
Master_User: replication
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: master-bin.000001
Read_Master_Log_Pos: 365506
Relay_Log_File: slave-relay-bin.000003
Relay_Log_Pos: 254
Relay_Master_Log_File: master-bin.000001
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1007
Last_Error: Error 'Can't create database 'bdd1'; database exists' on query. Default database: 'bdd1'. Query: 'create database bddf1'
Skip_Counter: 0
Exec_Master_Log_Pos: 107
Relay_Log_Space: 365810
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
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1007
Last_SQL_Error: Error 'Can't create database 'bdd1'; database exists' on query. Default database: 'bdd1'. Query: 'create database bdd1'
Replicate_Ignore_Server_Ids:
Master_Server_Id: 1072
1 row in set (0.00 sec)