Backup:
mysqldump-uroot-p**-a-b-F--master-data=2--single-transaction--events >/root/all.sql
Recovery:
mysql-uroot-pvaren2100* </root/all.sql
Incremental recovery with Binlog logs
Take advantage of location recovery:
Mysqlbinlog--start-position= "154"--stop-position= "789694"/var/lib/mysql/mysql-bin.000002 | mysql-uroot-pvaren2100*
Bin-log Specifying the recovery database
Sub-Library Backup:
#!/bin/sh
Backpath=/root/gool/backup
Myuser=root
Mypass=gool
Mycmd= "Mysql-u$myuser-p$mypass"
mydump= "Mysqldump-u$myuser-p$mypass-x-b-f-R"
[!-D $BACKPATH] && mkdir-p $BACKPATH
Dblist= ' $MYCMD-e "show databases; | Sed 1d|egrep-v "_schema|mysql|sys"
For dbname in $DBLIST
Do
$MYDUMP $dbname |gzip >/root/gool/backup/${dbname}_$ (Date +%f). sql.gz
Done
Sub-database Sub-table backup:
#!/bin/sh
Backpath=/root/gool/backup
Myuser=root
Mypass=gool
Mycmd= "Mysql-u$myuser-p$mypass"
mydump= "Mysqldump-u$myuser-p$mypass-x-f-r"
[!-D $BACKPATH] && mkdir-p $BACKPATH
Dblist= ' $MYCMD-e "show databases; | Sed 1d|egrep-v "_schema|mysql|sys"
For dbname in $DBLIST
Do
Tblist= ' $MYCMD-e "show tables from $dbname;" | Sed 1d '
For TableName in $TBLIST
Do
Mkdir-p $BACKPATH/$dbname
$MYDUMP $dbname $tablename |gzip > $BACKPATH/${dbname}/${tablename}_$ (Date +%f). sql.gz
Done
Done
MySQL incremental backup and recovery combat