User Tools

Site Tools


mysqlbackup

This is an old revision of the document!


AutoMySQLBackup

AutoMySQLBackup is a small backup script for MySQL databases with a handling for daily, weekly and monthly backups.

Step 1: Install

sudo apt-get install automysqlbackup

Step 2: Configure

sudo nano /etc/default/automysqlbackup

The most important Setup values are

USERNAME=XXX
PASSWORD=YYY
BACKUPDIR="/var/lib/automysqlbackup"

Change rights for the config file (to protect the password):

sudo chmod 600 /etc/default/automysqlbackup

If the apt package of automysqlbackup was used it is not necessary to create a crontab entry, because the Installation created a script in the folder

/etc/cron.daily/
mysqlbackup.1391537270.txt.gz · Last modified: 04.02.2014 19:07 by derk