ssh slavedbhost echo "STOP SLAVE; CHANGE MASTER TO MASTER_HOST='masterdbhost', MASTER_USER='fritz', MASTER_PASSWORD='geheim', MASTER_AUTO_POSITION=1; START SLAVE" | mysql
ssh masterdbhost echo "STOP SLAVE; RESET MASTER; RESET SLAVE;" | mysql -h slavedbhost mysqldump -AREQc --single-transaction --triggers --opt --add-drop-database | mysql -h slavedbhost echo "START SLAVE;" | mysql -h slavedbhost echo "SHOW SLAVE STATUS \G;SHOW MASTER STATUS;SHOW SLAVE HOSTS;" | mysql -th slavedbhost