history recorder

steps:

1. vi /etc/my.cnf

   log_bin
   binlog_format = ROW
   server-id=2
   

2. full backup

   mysqldump -uroot -p --single-transaction --master-data=2 {db1} > db1.sql
   mysqldump -uroot -p --single-transaction --master-data=2 --databases {db1 db2} > b1.sql
   mysqldump -uroot -p --single-transaction --master-data=2 --all-databases > b1.sql
   

3. increment backup

   rsync -a --delete -e "ssh -p9812" --progress /var/lib/mysql/{hostname}-bin.* johnson@jserver:/dest/dir
   

4. restore full backup

   mysql -uroot -p < b1.sql
   

5. restore increment backup

   mysqlbinlog --start-position={start-position} {hostname}-bin.000002 | mysql -uroot -p (check b1.sql for start-position)