Shulou(Shulou.com)06/01 Report--

The following brings you about what is the MySQL database full and incremental backup content, I believe you must have seen similar articles. What's the difference between what we bring to everyone? Let's take a look at the body. I'm sure you'll get something after reading what full and incremental backups of MySQL databases are.

MySQL database backup: full backup + incremental backup * scheduled task: crontab-e-u root00 6 * * 1 / shell/mysqlbak.sh & > / dev/null00 23 * * 2-7 / shell/mysqladd.sh & > / dev/null* Backup database script (mysql): vim / shellplash mysqbak.shalloxxxxxxxxxxx [!-e / mysqldata] Thenmkdir / mysaldatafiDay= `date +% F`mysqldump-u root-p123456 mysql > / mysqldata/mysql.$Day.sql# chmod + x / shell/mysqbak.sh* backup data Library log script (all diary files): vim / shellbind _ mysqllogall.shexamples _ Name the log file with your own name, and store the log file in the / logdir directory # / baklogdir schedule binlog log backup directory if [!-e / baklogdir] Thenmkdir / baklogdirfifor log in `cat / logdir/ glk.index`dologname = `echo $log | awk-F "/"'{print $3} '`cp-rf / logdir/$logname / baklogdir/donechmod + x / shell/mysqllogall.sh**** * backup the database log script (add new diary file): vim / shellbalance mysqllogadd.shellpacpBINGRASHREBH logdir starts the binlog log Give the log file under your own name and store it in the / logdir directory # / baklogdir schedule binlog log backup directory if [!-e / baklogdir] Thenmkdir / baklogdirfifor log in `cat / logdir/ glk.index`dologname = `echo $log | awk-F "/"'{print $3} '`if [!-e / baklogdir/$logname] Then cp-rf / logdir/$logname / baklogdir/ fidonemysql-uroot-p123456-e "flush logs" & > / dev/nullchmod + x / shell/mysqllogadd.sh* today For beginners, MYSQL database backup, write it down here. 2016-05-27 21:50

For the above about what is full and incremental backup of MySQL database, do you think it is what you want? If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.