Hi ... i have just tried by nothing's changed! ... i mean ... now in the "show slave status" i can see the right master_log_filename, log_position etc. but the error persists!
What's wrong? help me please! Thanks and bye --- Maxime LEMAIRE <[EMAIL PROTECTED]> ha scritto: > 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 > ______________________________________________________________________ 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