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

Make a full hot backup of the extmail database at 01:00 every day, and can be fully restored!

First, create a backup script as follows:

Vi mysqlbackup extmailmailbox bak.shrowbak.shangxinxanxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx -databases $DB-- flush-logs-- single-transaction > $DumpFile/bin/tar czvf $GZDumpFile $DumpFile/bin/rm $DumpFileLast= `date + "Y% m% d% H:%M:%S" `echo start: $Begin end: $Last $GZDumpFile succ > > $LogFile

2. Restore the backup sql file as follows:

Cd / mysqlbacktar zxvf extmail20170515.tar.gzmv extmail20170515.sql extmail.sqlmysql-uroot-p < extmail.sql

Attached mysqldump parameter description: http://www.cnblogs.com/wxb-km/p/3610594.html this big brother wrote in great detail!

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.