Using automysqlbackup to create regular backups of your database

This works on Debian and Ubuntu, but also on other distributions. The package can be installed via apt: apt-get install automysqlbackup For yum (Fedora, CentOS, RedHat, etc.) there's usually also a package provided. Next you need to edit the configuration file /etc/default/automysqlbackup. There are other options, the most important ones are: USERNAME=root PASSWORD=…….. DBHOST=localhost DBNAMES=`mysql –defaults-file=/etc/mysql/debian.cnf […]

Backups to S3 using Duplicity

First install Duplicity with its dependancies: apt-get install haveged python-paramiko python-boto python-gobject-2 duplicity Then generate a gpg key: gpg −−gen-key The output might be like this (just confirm everything with return and keep aside the password you'll have to enter): gpg (GnuPG) 1.4.12; Copyright (C) 2012 Free Software Foundation, Inc. This is free software: you […]

mysql data files backup using mysqlhotcopy   Recently updated !

With mysqlhotcopy you can create a copy of your database data files. Compared to mysqldump, mysqlhotcopy does not create sql commands, but creates a copy of the files residing in /var/lib/mysql (may differ depending on your installation). The hotcopy can be created while the server is running, you don't need to stop it. Basically mysqlhotcopy […]

Creating database backups using mysqldump   Recently updated !

In this article I'd like to show how one can create a backup of a mysql database. The most basic example, is to create a full backup of your database, including structure and data. I'm creating the backups in the folder /backup. You can use any other folder you want. The same for user root […]

Creating incremental backups with rsnapshot   Recently updated !

Some important information at the beginning about rsnapshot: rsnapshot is not creating a full backup every time, it's creating incremental backups to save space. Therefore rsnapshot is using hard links and creating a folder structure containing daily.0, daily.1, weekly.0, weekly.1, etc.