Shulou(Shulou.com)05/31 Report--

This article focuses on "automatic backup MYSQL linux script sharing", interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Now let the editor to take you to learn "automatic backup MYSQL linux script sharing" bar!

This is a script I wrote to automatically back up MYSQL, which can back up everything in all MYSQL.

#! / bin/bashumask 177MUSER = "userid" MPASS= "password" MHOST= "localhost" MYSQL= "$(which)" MYSQLDUMP= "$(which mysqldump)" PARAMS= "--hex-blob-- skip-extended-insert-- password=$MPASS" DATE= "$(date +% F)" BACKUPDIR= "/ home/$ {MUSER} / BACKUP/$DATE/" RMDATE= "$(date-d" 1 week ago "+% F)" RMDIR= "/ home/$ {MUSER} / BACKUP/$RMDATE" BACKUPLOG= "/ home/$ {MUSER} / BACKUP/backup .log "if [!-f $BACKUPLOG] Thentouch $BACKUPLOGchmod 600$ BACKUPLOGfiif [- d $RMDIR]; thenrm-rf $RMDIRecho "Backup DELETED from" $RMDATE > > $BACKUPLOGfiif [!-d $BACKUPDIR]; thenmkdir-m 700-p $BACKUPDIRfiecho "Backup BEGINNING" $DATE > > $BACKUPLOGDBS= "$($MYSQL-h $MHOST-u $MUSER-p$MPASS-Bse 'show databases')" for db in $DBSdo$MYSQLDUMP $PARAMS $db > $BACKUPDIR$db.sql & & bzip2-best $BACKUPDIR$db.sqldoneecho "Backup COMPLETED" $DATE > $BACKUPLOG

In addition, regular backups can be combined with CRONJOB.

At this point, I believe you have a deeper understanding of "linux script sharing for automatic backup of MYSQL". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.