MySQL Forums
Forum List  »  Replication

Mysql replication
Posted by: rock well
Date: March 15, 2005 12:25PM

hi all,
i am trying to replicate mysql database from one server to an other. I made one server by changing its my.cnf file and assigning it a serverid. This how the master's my.cnf file looks like
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
server-id=1

Then i tried to setup the replication as given in mysql documentation. I created an account using the grant replication slave on command. I flushed the tables with read lock, and copied the mysqlsnaphot.tar to the slave file. When the read lock exists i checked the master status but it shows as an "Empty set".

My slave my.cnf file looks like
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
master-host=master host name
master-user=user on master
master-password=slave password
server-id=2

I followed the steps as given in the documentation but it doesnt work. Can you tell me what would be the problem. If you need some other information i will post it next time.

Thanks

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql replication
2967
March 15, 2005 12:25PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.