Re: Mysql Replication out of sync

2009-01-09 Thread Shain Miley
Jose, Thank you very much...I found that fix a few minutes before I read your email...however I really appreciate your assistance. Just an FYI to anyone one else though...I had to skip a total of 2 queries (I executed SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; two times) because of the particul

Re: Mysql Replication out of sync

2009-01-09 Thread Jose Julian Buda
maybe if you put on the slave server : mysql> STOP SLAVE; mysql> SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 1; mysql> START SLAVE; then just to check take a look at this lines : mysql> show slave status\G; ... Slave_IO_Running: Yes Slave_SQL_Running: Yes ... it will restart the r