PDA

View Full Version : Problem with REPLICATION


zimele
4th September 2006, 10:42
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

falko
5th September 2006, 19:40
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.).