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