主 192.168.229.129
select user,host,password from mysql.user;
用户授权:
grant all on *.* to user@192.168.229.130 identified by "xiaobai";
或者
grant replication slave on *.* user@192.168.229.130 identified by "xiaobai"
从 192.168.229.130
mysql -h 192.168.229.129 -u user -pxiaobai
Mysql bin-log日志
show variables like "%bin%";
log_bin | ON
说明bin-log日志已经开启
与bin-log有关的日志刷新
mysql>flush logs;
此时就会多一个最新的bin-log日志
mysql>show master status;
查看最后一个bin日志
mysql>reset master
清空bin日志
查看mysql-bin日志
/usr/local/mysql/bin/mysqlbinlog mysql-bin.000002
数据恢复
mysql> show master status; //当前的bin-log是000002
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000002 | 434 | | |
+------------------+----------+--------------+------------------+
1 row in set (0.00 sec)
insert into t1 values(1);
insert into t1 values(2);
insert into t1 values(3);
mysql> show master status; //bin-log的位置发生变化
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000002 | 456 | | |
+------------------+----------+--------------+------------------+
flush logs;//此时bin-log变为000003
mysql> show master status;
+------------------+----------+--------------+------------------+
| File | Position | Binlog_Do_DB | Binlog_Ignore_DB |
+------------------+----------+--------------+------------------+
| mysql-bin.000003 | 98 | | |
+------------------+----------+--------------+------------------+
truncate test.t1; //清空数据
//海原数据
/usr/local/mysql/bin/mysqlbinlog --no-defaults mysql-bin.000002 | mysql -uroot -pxiaobai test