通过二进制文件恢复数据
mysqlbinlog Server4-bin.000003 Server4-bin.000004 | mysql -p’GaoYong@123’
mysqlbinlog local1-bin.000003 –start-position=154 | mysql -uroot -p’GaoYong@123’
mysqlbinlog local1-bin.000003 –stop-position=778 | mysql -uroot -p’GaoYong@123’
mysqlbinlog local1-bin.000003 –start-position=780 | mysql -uroot -p’GaoYong@123’
mysql通过二进制文件(binlog)恢复数据
未经允许不得转载:爱站程序员基地 » mysql通过二进制文件(binlog)恢复数据