5

Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

view full story
linux-howto

http://howtoforge.com – Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10 AutoMySQLBackup is a shell script that lets you take daily, weekly and monthly backups of your MySQL databases using mysqldump. It can back up multiple databases, compress the backups, back up remote databases, and email the logs. This tutorial explains how to install and use it on an Ubuntu 9.10 server. (HowTos)

hwq123's picture
Submitted by hwq123 on 02/18/2010 – Made popular on 02/18/2010

Stories similar to Creating MySQL Backups With AutoMySQLBackup On Ubuntu 9.10

When I started managing a server, due to small database I always took manual backups, scarcely though. And because of my laziness in doing so, my fellow author, shredder12 constantly bugged me to do so. So, I started with weird entries in cron until I find this awesome script.

I have automysqlbackup running on Ubuntu 10.04 and it works perfectly fine. I currently have it performing daily backups for all databases, but I would like to adjust the configuration to do the following:

Perform daily backups of all databases into one folder but as separate .sql files, and then have that folder be a gzip with the timestamp the backup performed.

I was wondering if anyone else h

I am backing up my cPanel server databases with automysqlbackup, in /etc/automysqlbackup.conf I have set: CONFIG_db_exclude=( 'information_schema' 'cphulkd' 'eximstats' 'leechprotect' 'mysql' 'modsec' )

But I am getting the following errors:

###### WARNING ###### Errors reported during AutoMySQLBackup execution..

As a host, I've always wanted to store multiple copies of my users backups.

How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10 mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a...

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so.

How To Back Up MySQL Databases With mylvmbackup On Debian Lenny

I set up a cron job on my server running RedHat 4.1 to backup MySQL databases, and then upload to Amazon S3. The goal is to drop the .bz2 file in a folder corresponding with the day of the week.

I need help creating a backup script for Rackspace Cloud sites.

The sites need daily backups for both the web site & their mysql databases (some sites have as many as 4 databases), the backups then need to be ftp'd off-site.

It appears that i can only achieve this via cron jobs. Rackspace show an example backup script but only show how to push files to cloudfile storage (see below).

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the t ...