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
