Re: Mysql réplication
Le samedi 3 mars 2007 11:05, Vincent Bernat a écrit :
> OoO En cette matinée ensoleillée du samedi 03 mars 2007, vers 09:47,
>
> Bulot Grégory <debian.list@batman.dyndns.org> disait:
> >> Tu as fait start slave ?
> >
> > ooops
> >
> >
> > start slave;
> > ERROR 1200 (HY000): The server is not configured as slave; fix in config
> > file or with CHANGE MASTER TO
>
> Tu n'as pas utilisé change master to ? Regarde la doc de MySQL, c'est
> expliqué pas à pas.
si (comme dans
http://randomspark.wordpress.com/2006/09/18/mysql-replication-setting-up-the-slave/
slave stop;
Query OK, 0 rows affected, 1 warning (0.00 sec)
mysql> CHANGE MASTER TO MASTER_HOST='192.168.1.33', MASTER_USER='xxxxxxxxx',
MASTER_PASSWORD='xxxxxxxxxxx', MASTER_LOG_FILE='mysql-bin.000147' ;
Query OK, 0 rows affected (0.00 sec)
mysql> slave start ;
ERROR 1200 (HY000): The server is not configured as slave; fix in config file
or with CHANGE MASTER TO
Reply to: