Error :
mysql> SHOW MASTER STATUS;
Empty set (0.00 sec)
log-bin = /var/lib/mysql/mysql-bin.log
#mysql –u root –p (login in mysql and run command)
mysql> SHOW MASTER STATUS;
+----------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+--------------+------------------+
| mysql-bin.000001 | 107 | xyzdb | |
+----------------+----------+--------------+------------------+
1 row in set (0.00 sec)
mysql>
mysql> SHOW MASTER STATUS;
Empty set (0.00 sec)
Soluton :
#touch /var/lib/mysql/mysql-bin.log
#vi /etc/my.cnflog-bin = /var/lib/mysql/mysql-bin.log
save and exit.
#service mysqld restart#mysql –u root –p (login in mysql and run command)
mysql> SHOW MASTER STATUS;
+----------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+----------------+----------+--------------+------------------+
| mysql-bin.000001 | 107 | xyzdb | |
+----------------+----------+--------------+------------------+
1 row in set (0.00 sec)
No comments:
Post a Comment