分享到:
发表于 2008-12-12 02:54:00 楼主 | |
主服务器,运行如下命令怎么 Binlog_Do_DB 显示为空呢? 我在my.cnf中设置过要同步数据库啊? mysql> SHOW MASTER STATUS; +-------------------+----------+--------------+------------------+ | File | positiion | Binlog_Do_DB | Binlog_Ignore_DB | +-------------------+----------+--------------+------------------+ | mysqld-bin.000001 | 98 | | | +-------------------+----------+--------------+------------------+ 1 row in set (0.00 sec) my.cnf设置如下所示 [mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql # Default to using old password format for compatibility with mysql 3.x # clients (those using the mysqlclient10 compatibility package). old_passwords=1[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pidlog-bin=mysql-bin.log binlog-do-db=school server-id=1 |
|
楼主热贴 |
发表于 2008-12-12 22:24:00 1楼 | |
基本的配置文件的规则要正确 [mysqld] log-bin=mysql-bin.log binlog-do-db=school server-id=1 请正确修改,而且要在mysql client进行命令的执行 |
|
针对ZOL星空(中国)您有任何使用问题和建议 您可以 联系星空(中国)管理员 、 查看帮助 或 给我提意见