轻量级MySQL备份方案：AutoMySQLBackup_MySQL

<ol class="dp-xml"><li class="alt">shell> mkdir /etc/automysqlbackup </li><li>shell> sed -n '/START CFG/,/END CFG/s/^/s*//p' automysqlbackup.sh / </li><li class="alt">           > /etc/automysqlbackup/automysqlbackup.conf </li></ol>

<ol class="dp-xml"><li class="alt"># Username to access the MySQL server e.g. dbuser </li><li>USERNAME=debian </li><li class="alt"> </li><li># Password to access the MySQL server e.g. password </li><li class="alt">PASSWORD= </li><li> </li><li class="alt"># Host name (or IP address) of MySQL server e.g localhost </li><li>DBHOST=localhost </li><li class="alt"> </li><li># List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3" </li><li class="alt">DBNAMES="all" </li><li> </li><li class="alt"># Backup directory location e.g /backups </li><li>BACKUPDIR="/srv/backup/db" </li><li class="alt"> </li><li># Mail setup </li><li class="alt"># What would you like to be mailed to you? </li><li># - log   : send only log file </li><li class="alt"># - files : send log file and sql files as attachments (see docs) </li><li># - stdout : will simply output the log to the screen if run manually. </li><li class="alt"># - quiet : Only send logs if an error occurs to the MAILADDR. </li><li>MAILCONTENT="log" </li></ol>

<ol class="dp-xml"><li class="alt">shell> cp /path/to/automysqlbackup.sh /etc/cron.daily/automysqlbackup </li><li>shell> chmod +x /etc/cron.daily/automysqlbackup </li></ol>

<ol class="dp-xml"><li class="alt">shell> find /path/to/backup/dir -type f -mtime +N -print0 | xargs -0 rm -f </li></ol>