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 MySQL password):

sudo chmod 600 /etc/default/automysqlbackup

Setting up a cronjob manually is not necessary. The apt package of automysqlbackup created a script for that in the Folder:

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