linux2 ~ # /etc/init.d/mysql stop * Stopping mysql ... * Stopping mysqld (0) [ ok ] linux2 ~ # updatedb linux2 ~ # locate master.info /var/lib/mysql/master.info linux2 ~ # rm /var/lib/mysql/master.info linux2 ~ # locate mysqld-relay /var/run/mysqld/mysqld-relay-bin.000001 /var/run/mysqld/mysqld-relay-bin.000007 /var/run/mysqld/mysqld-relay-bin.000003 /var/run/mysqld/mysqld-relay-bin.000002 /var/run/mysqld/mysqld-relay-bin.000006 /var/run/mysqld/mysqld-relay-bin.000004 /var/run/mysqld/mysqld-relay-bin.index /var/run/mysqld/mysqld-relay-bin.000005 linux2 ~ # \rm /var/run/mysqld/mysqld-relay-bin.* linux2 ~ # /etc/init.d/mysql restart * Starting mysql ... * Starting mysql (/etc/mysql/my.cnf) [ ok ] linux2 ~ # mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.0.44-log Gentoo Linux mysql-5.0.44-r1 Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> CHANGE MASTER TO MASTER_HOST = 'linux1.fluidlino.com.au', MASTER_USER = 'rep_user', MASTER_PASSWORD = 'mypassword', MASTER_PORT = 3306, MASTER_CONNECT_RETRY = 30, MASTER_LOG_FILE = 'mysqld.000010', MASTER_LOG_POS = 268; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log mysql> start slave; ERROR 1201 (HY000): Could not initialize master info structure; more error messages can be found in the MySQL error log ================================================ 071116 10:20:19 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=/var/run/mysqld/mysqld-relay-bin' to avoid this problem. 071116 10:20:19 [ERROR] Failed to open the relay log '/var/run/mysqld/mysqld-relay-bin.000025' (relay_log_pos 232) 071116 10:20:19 [ERROR] Could not find target log during relay log initialization 071116 10:20:23 [ERROR] Error reading master configuration ================================================ # ls -la /var/run/mysqld/ total 40 drwxr-xr-x 2 mysql mysql 4096 Nov 16 10:20 . drwxr-xr-x 5 root root 4096 Nov 16 10:18 .. -rw-r--r-- 1 mysql mysql 0 Nov 15 17:15 .keep_dev-db_mysql-0 -rw-rw---- 1 mysql mysql 117 Nov 16 09:38 mysqld-bin.000001 -rw-rw---- 1 mysql mysql 117 Nov 16 10:10 mysqld-bin.000002 -rw-rw---- 1 mysql mysql 117 Nov 16 10:17 mysqld-bin.000003 -rw-rw---- 1 mysql mysql 98 Nov 16 10:18 mysqld-bin.000004 -rw-rw---- 1 mysql mysql 136 Nov 16 10:18 mysqld-bin.index -rw-rw---- 1 mysql mysql 117 Nov 16 10:20 mysqld-relay-bin.000001 -rw-rw---- 1 mysql mysql 40 Nov 16 10:20 mysqld-relay-bin.index -rw-rw---- 1 mysql mysql 5 Nov 16 10:18 mysqld.pid srwxrwxrwx 1 mysql mysql 0 Nov 16 10:18 mysqld.sock ================================================ # ls -lh /var/lib/mysql/ total 21M drwx------ 2 mysql mysql 4.0K Nov 14 12:01 dns -rw-rw---- 1 mysql mysql 5.0M Nov 16 10:31 ib_logfile0 -rw-rw---- 1 mysql mysql 5.0M Nov 9 11:23 ib_logfile1 -rw-rw---- 1 mysql mysql 10M Nov 16 10:30 ibdata1 -rw-rw---- 1 mysql mysql 0 Nov 16 10:20 master.info drwx------ 2 mysql mysql 4.0K Nov 8 15:20 mysql -rw-rw---- 1 mysql mysql 62 Nov 15 08:03 relay-log.info drwx------ 2 mysql mysql 4.0K Nov 8 15:20 test