Hi All, We have setup master/slave replication in our production site. I took a mysqldump from slave using this command
/usr/bin/mysqldump --user=andale -h prod -p abc --opt --all-databases --master-data=2 --flush-privileges --single-transaction > reports.dump When i checked reports.dump, it showing as -- CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin.000003', MASTER_LOG_POS=311; But before i started the mysqldump, I did the below on slave db. show slave status\G Master_Log_File: mysql-bin.000029 Read_Master_Log_Pos: 106683511 Relay_Log_File: relay-log.039071 Relay_Log_Pos: 106683648 Relay_Master_Log_File: mysql-bin.000029 Slave_IO_Running: Yes Slave_SQL_Running: Yes As see in the mysqldump is saying to start recovery from bin-log file "' mysql-bin.000003'" and position="MASTER_LOG_POS=311", but the current master bin-log and postion as seen from above is different. So, if restore the dump to a new machine and apply bin-logs at regulare interval, from which bin-log should i start and from which position. Please help, regards anandkl
