I Followed the doc:
http://members.cox.net/midian/howto/...eplication.htm for setting Up Master-Slave Replication but stuck with the following step:
Code:
mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin',MASTER_LOG_POS=/var/log/mysqld.log;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/var/log/mysqld.log' at line 1
What is the correct command for this?
Alternately I tried entering this into /etc/my.cnf on client side:
Code:
server-id=2
master-host=10.14.2.146
master-user=repl
master-password=mysql123
master-connect-retry=60
replicate-do-db=helpcore
master-port = 3306
When I run the following commad at slave side:
Code:
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000038 | 14152 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql>
The same at the Master side are:
Code:
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000004 | 2383 | | mysql |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql>
I followed step by step configuration but its throwing error:
Code:
mysql> CHANGE MASTER TO MASTER_LOG_FILE='mysql-bin',MASTER_LOG_POS=/var/log/mysqld.log;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/var/log/mysqld.log' at line 1
Pls Help !!!