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