hi...
i have setup the mysql replication but i dont know for some reason its not replicating the data.. i may be missing some configuration.. please help me... to do the same..
Thanks in advance..
Pooran Jaiswal
my.cnf entries on slave server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking
old_passwords=1
server-id=3
master-host=192.168.x.x
master-port=3306
master-user=yyyyyyyy
master-password=xxxxx
log-bin=/var/log/mysql/bin.log
log-bin-index=/var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
relay-log=/var/log/mysql/relay.log
relay-log-info=/var/log/mysql/relay-log.info
relay-log-index=/var/log/mysql/relay-log.index
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
my.cnf entries on master server
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
skip-networking
old_passwords=1
server-id=1
log-bin=/var/log/mysql/bin.log
log-bin-index=/var/log/mysql/log-bin.index
log-error=/var/log/mysql/error.log
binlog-do-db=somedb
binlog-ignore-db=mysql
binlog-ignore-db=test
[mysql.server]
user=mysql
basedir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
socket=/var/lib/mysql/mysql.sock
datadir=/var/lib/mysql