Master / Salve DB Server Config Error
 

Hi Guys,

I am trying to configure Master/Slave DB Server replication...where as when i configured the Master DB Server and checking the status by..

mysql> show master status;
Empty set (0.00 sec)

how to overcome the error...

my configuration...

vim /etc/my.cnf

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-bin=/var/log/mysqld/mysql-bin.log

server-id=1
bind-address=172.31.1.76
binlog_do_db=masterdb

...........
so after checking the log file its shows the error...

130620 14:50:49 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.69' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
130620 14:51:26 [ERROR] Cannot find or open table masterdb/users from
the internal data dictionary of InnoDB though the .frm file for the
table exists. Maybe you have deleted and recreated InnoDB data
files but have forgotten to delete the corresponding .frm files
of InnoDB tables, or you have moved .frm files to another database?
or, the table contains indexes that this version of the engine
doesn't support.

Please me to sort the problem...

Try moving the log-bin settings from under [mysqld_safe] up to being under [mysqld] and then restarting MySQL.

I had a simalar issue setting up the Master Slave and finally got it working when I opened up the ports in the firewall.