Hi all Please help me fix error in mysql master I config server 1 to Master server . [mysqld] server-id = 2 [-----------] log-bin = /var/lib/mysql/mysql-master-bin.log binlog-do-db = sinhvien binlog-ignore-db = mysql relay-log=GTWebFMaster-relay-bin [-----------] I use command show master status; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 4166476 Current database: *** NONE *** | File | Position | Binlog_Do_DB | Binlog_Ignore_DB | +-------------------------+-----------+-------------------------+------------------+ | mysql-master-bin.001262 | 525103035 | sinhvien,sinhvien | mysql,mysql | and error duplicate table
Is the master configured to allow remote connections? What's the output of netstat -tap on the master? What's in my.cnf on the master and the slave? Which tutorial (URL) did you use?
