I was wondering is there a script that i can run that makes replication happen automatically cause i noticed that when my Mydns server needed to restart cause i am using dns replication the slave these configs +---------------+----------+--------------+------------------+ | File | Position | Binlog_do_db | Binlog_ignore_db | +---------------+----------+--------------+------------------+ | mysql-bin.013 | 4 | mydns | | +---------------+----------+--------------+------------------+ and it started being unable to resolve properly off my secondary DNS server
I don't know of such a script. I think you'll have to do most of the steps of the MySQL Replication tutorial again (copy over the data from the master to the slave, check the master status, etc.).