What would also help is English. Would you translate the messages for us? -----Original Message----- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 3:19 PM To: 'Scott Helms'; [EMAIL PROTECTED] Subject: R: R: Replication don't work.
Sigh..... Master.err 030401 1:14:42 MySql: Forzata la chiusura del thread 13 utente: 'titti' 030401 1:14:42 MySql: Forzata la chiusura del thread 12 utente: 'ODBC' 030401 1:14:42 MySql: Forzata la chiusura del thread 11 utente: 'geofor' 030401 1:14:42 MySql: Forzata la chiusura del thread 5 utente: 'ODBC' 030401 1:14:42 MySql: Forzata la chiusura del thread 2 utente: 'ODBC' 030401 1:14:42 MySql: Forzata la chiusura del thread 1 utente: 'massi' 030401 1:14:42 MySql: Shutdown completato MySql: Pronto per le connessioni (ready for connection) Slave.err 030401 1:04:17 Slave: connected to master '[EMAIL PROTECTED]:3306', replication started in log 'webserver-bin.010' at position 73 Master.info of slave webserver-bin.010 73 xx.xx.xx.x replica pwdreplica 3306 60 My.ini of master [mysqld] skip-innodb basedir=C:/mysql datadir=C:/mysql/data log-bin server-id=1 language=C:/mysql/share/italian binlog-do-db=Zope My.ini of slave [mysqld] skip-innodb port=3306 language=c:/programmi/mysql/share/italian server-id=12 master-host=xx.xx.x.xx master-user=replica master-password=pwdreplica master-port=3306 basedir=C:/Programmi/mysql/ datadir=C:/Programmi/mysql/data/ replicate-do-db=Zope -----Messaggio originale----- Da: Scott Helms [mailto:[EMAIL PROTECTED] Inviato: marted́ 1 aprile 2003 0.46 A: trashMan Cc: 'Jennifer Goodie'; mysql Oggetto: Re: R: Replication don't work. Massi, You will get much better results if you provide the following: Copies of: my.cnf file from both master and slave (look in $MYSQL/data or /etc) $HOSTNAME.err logs from master and slave master.info file from slave (look in $MYSQL/data directory) and check that one does not exist on the master, this gave me fits for several hours one day while moving a slave to being the master when the then current master died of a bad hard drive. No guarantees, but this will greatly improve your chances of an intelligent answer. ;p Scott Helms On Mon, 2003-03-31 at 17:04, trashMan wrote: > The error.log on the master dont' report anything... > > MySql: ready for connections > > Other info > > >Show master status; > > ******************************************* > Header answer note > ******************************************* > File webserver-bin.008 > Position 73 > > > > >SHOW PROCESSLIST > > *************** > Header answer > *************** > User userreplica > Host XXXXX > Db NULL > Command Binlog dump > Time XXXX (the time passed from the mysql > start) > Query connect > Time XXXX (the time passed from the mysql > State slave connection: waiting for binlog update > > > :-/ > > Massi > > > > > > -----Messaggio originale----- > Da: Jennifer Goodie [mailto:[EMAIL PROTECTED] > Inviato: luned́ 31 marzo 2003 23.41 > A: trashMan; [EMAIL PROTECTED] > Oggetto: RE: Replication don't work. > > > It the master actually writting to the binlog? What does the master > say when you run SHOW MASTER STATUS? Is the size of the binlog > growing? > > -----Original Message----- > From: trashMan [mailto:[EMAIL PROTECTED] > Sent: Monday, March 31, 2003 1:29 PM > To: [EMAIL PROTECTED] > Subject: Replication don't work. > > > There are two weeks i try it...but...the replication don't start!! > > I've follow the istruction > http://www.mysql.com/doc/en/Replication_HOWTO.html without success. > > In the slave i have: > > >Show slave status; > > ******************************************* > Header answer note > ******************************************* > Slave_Running YES > Last_Error none > > > >SHOW PROCESSLIST > > *************** > Header answer > *************** > User system user > Host none > Db NULL > Query connect > Time XXXX (the time passed from the mysql > start) > State Reading master update > > > I think the database is in updating...but the table are the same....i > don't have new data!! What can i do??? :-( > > Help! > > Massi > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
