hi, try this : mysql > SHOW MASTER STATUS; +--------------+------------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +--------------+------------+--------------+----- ------------+ | some-file | XX | | | +--------------+------------+--------------+------------------+ mysql> CHANGE MASTER TO MASTER_HOST='host', MASTER_USER='repl', MASTER_PASSWORD='repl', MASTER_LOG_FILE='some-file', MASTER_LOG_POS=XX;
then restart the slave. -----Message d'origine----- De : Natale Babbo [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 12 décembre 2002 16:27 À : [EMAIL PROTECTED] Objet : Fwd: problem with replication Any suggestion about this error? Thanks to all. --- Natale Babbo <[EMAIL PROTECTED]> ha scritto: > Data: Wed, 11 Dec 2002 17:03:51 +0100 (CET) > Da: Natale Babbo <[EMAIL PROTECTED]> > Oggetto: problem with replication > A: [EMAIL PROTECTED] > > Hi all, > > I have a problem with replication between two > servers. > I created user repl on the master, I restored the > master's dump on the slave, I changed both my.cnf > settings but I got this error from slave .err file: > > MySql: ready for connections > 021211 16:56:12 InnoDB: Started > 021211 16:56:12 Slave I/O thread: connected to > master > 'repl@sviluppo01:3306', replication started in log > 'FIRST' at position 4 > 021211 16:56:12 Error updating slave list: Query > error > 021211 16:56:12 Slave I/O thread exiting, read up > to > log 'FIRST', position 4 > > Master my.cnf: > log-bin=/usr/local/mysql/log/MySQL-bin > server-id=1 > > Slave My.ini: > server-id=2 > master-host=sviluppo01 > master-user=repl > master-password=repl > > What's wrong? > > Thanks in advance. > > ______________________________________________________________________ > Yahoo! Foto: salva, ritocca, condividi e ordina > stampe professionali > http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com > ______________________________________________________________________ Yahoo! Foto: salva, ritocca, condividi e ordina stampe professionali http://it.yahoo.com/mail_it/foot/?http://it.photos.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
