mysql自动定时主从同步_请教mysql 定时 双向 主从同步問題

--主机开两个窗口，一个进入mysql，一个是shell--主机阻断写操作mysql>FLUSHTABLESWITHREADLOCK;QueryOK,0rowsaffected(0.00sec)mysql>mysql>mysql>SHOWMASTERSTATUS;+------------------+----------+--------------+------------------+|File|Position|Binlog_Do_DB|Binlog_Ignore_DB|+------------------+----------+--------------+------------------+|mysql-bin.000002|1529881|openser|mysql,test|+------------------+----------+--------------+------------------+1rowinset(0.00sec)--另外一个窗口导出主机数据库mysqldump-uroot-p123456--opt-Ropenser>openser20121203.sql--刚才的窗口主机解锁mysql>UNLOCKTABLES;QueryOK,0rowsaffected(0.00sec)mysql>--打包数据文件到从机dropdatabaseopenser;createdatabaseopenser;mysql-uroot-p123456openser

取消

评论