The show master status is saying I'm On the bin log file 8 at position 73 (right after the header of the bin log)
Some helpful checks Make sure in your data dir (for this example /var/lib/mysql) Hostname.index contains all the binlogs especially the one that the slave is pointing to. Execute show slave status on the slave Next make sure that all the mysql bin log files are owned by mysql and not by root or some other user Execute chown -R mysql:mysql /var/lib/mysql Then insert a row in a database make sure the position changes from 73 to another value (going to be a size in bytes the query is). Watch the slave to see if the same number changes. These are some good steps to verify / find an issue with replication. -----Original Message----- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 2:11 PM To: trashMan; [EMAIL PROTECTED] Subject: RE: Replication don't work. What position and in what binlog does your slave show it is at? It might be helpful if you post the entire output of show slave status (minus user and host if you are concerned about that for some reason). -----Original Message----- From: trashMan [mailto:[EMAIL PROTECTED] Sent: Monday, March 31, 2003 2:04 PM To: 'Jennifer Goodie'; [EMAIL PROTECTED] Subject: R: Replication don't work. 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]
