mysql数据备份和恢复

 mysqldump -uroot -p123 -A --master-data=2 > /tmp/full1.sql
  997  mysqldump -uroot -p123 -A > /tmp/full.sql
  998  vim /tmp/full.sql
  999  vimdiff /tmp/full.sql /tmp/full1.sql 
 1000  vim /tmp/full1.sql 
 1001  /etc/init.d/mysqld start
 1002  mysql -uroot -p123
 1003  mysql -uroot -p123 < /tmp/full.sql
 1004  mysql -uroot -p123
 1005  mysql -uroot -p123 < /tmp/full1.sql 
 1006  mysql -uroot -p123
 1007  ll /usr/local/mysql/data
 1008  cd /usr/local/mysql/data
 1009  ll
 1010  mysqlbinlog mysql-bin.000005
 1011  vim /tmp/full1.sql 
 1012  mysqlbinlog mysql-bin.000005
 1013  mysqlbinlog mysql-bin.000005 |less
 1014  mysqlbinlog --start-position=434 --stop-position=844
 1015  mysqlbinlog --start-position=434 --stop-position=844 mysql-bin.000005
 1016  mysqlbinlog --start-position=434 --stop-position=844 mysql-bin.000005 > /tmp/egon.sql
 1017  mysql -uroot -p123 < /tmp/egon.sql 
 1018  mysql -uroot -p123
 1019  mysqldump -uroot -p123 -A --master-data=1 > /tmp/full2.sql
 1020  vim /tmp/full2.sql 
 1021  mysqldump -uroot -p123 -A --master-data=0 > /tmp/full3.sql
 1022  vim /tmp/full3.sql 
 1023  mysqldump -uroot -p123 -A -R --triggers --master-data=2 --single-transaction |gzip > /tmp/$(date +%F)_full.sql.gz
 1024  ll /tmp/
 1025  date -s 20191026
 1026  mysqldump -uroot -p123 -A -R --triggers --master-data=2 --single-transaction |gzip > /tmp/$(date +%F)_full.sql.gz