shadow_man
Executive Member
I just blogged a basic install fur AutoMySQLBackup if anyone is interested.
Useful for backup up your MYSQL db's. If anyone is interested:
http://jerome.co.za/automysqlbackup-backing-up-your-sql-dbs/
------------------------------------------------------------------------
AutoMySQLBackup – Backing up your SQL db’s!
Hi folks, its been a while since i’ve written anything so I decided to post a quick guide on backing up your MySQL db’s.
To do this we’re going to use a tool called AutoMySQLBackup.
Found here:
http://sourceforge.net/projects/automysqlbackup/
——————————–
Install AutoMySQLBackup
——————————–
For Debian based Linux systems:
apt-get update
apt-get install automysqlbackup
OR
We can download and install manually from their SourceFourge page.
Visit http://sourceforge.net/projects/automysqlbackup/ and grab the latest copy.
I’ll use wget to grab mine and proceed with the install:
mkdir /downloads/automysqlbackup/
cd /downloads/automysqlbackup/
wget http://ufpr.dl.sourceforge.net/proj...ackup VER 3.0/automysqlbackup-v3.0_rc6.tar.gz
tar xzvf automysqlbackup-v3.0_rc6.tar.gz
./install.sh
At the Select the global configuration directory prompt, type the path where the configuration files will be stored.
At the Select directory for the executable prompt, type the path where the program file will be stored.
*NOTE: I use the default paths provided.
*NOTE2: If you use the latter installation method then you will need to install Mutt to be able to send backups via email.
———————————-
Configuring AutoMySQLBackup
———————————-
Edit your myserver.conf located in the configuration directory you specified previously.
pico /etc/automysqlbackup/myserver.conf
To configure basic backup settings, uncomment the following lines in the myserver.conf file, and then change the values to match your own installation:
CONFIG_mysql_dump_username='username'
CONFIG_mysql_dump_password='password'
CONFIG_backup_dir='/home/yourpath/mysqlbackups/'
*NOTE: Make sure you use a MySQL username and password, and not the username and password you use to log in to SSH. Addtionally, make sure that the path you specify for the backup directory exists. AutoMySQLBackup does not automatically create the directory.
To specify specific databases to back up, uncomment following line, and change the value to the databases you want to back up:
CONFIG_db_names=()
*NOTE: By default, AutoMySQLBackup backs up all MySQL databases. You only need to change this setting if you want to back up specific databases.
To specify rotation settings for the different backup intervals, uncomment the following lines, and then change the values to the rotation settings that you want:
CONFIG_rotation_daily=6
CONFIG_rotation_weekly=35
CONFIG_rotation_monthly=150
To send backup files to an e-mail account, uncommentthe following lines, and then modify them as shown. Replace [email protected] with the e-mail address where you want to send the backup files:
CONFIG_mailcontent='files'
CONFIG_mail_address='[email protected]'
————————————
Running Backups
————————————
After you configure AutoMySQLBackup for your environment, you can run backups. To run a backup manually using AutoMySQLBackup, type the following command. Replace path with the path to the myserver.conf file:
automysqlbackup "path/myserver.conf"
If you want to automate this, then you may want to add a CRON entry to do so!
Remember – always make sure to test your backups, you don’t want to have to rely on something that may be flawed. Restore, test, rinse and repeat regularly!
Useful for backup up your MYSQL db's. If anyone is interested:
http://jerome.co.za/automysqlbackup-backing-up-your-sql-dbs/
------------------------------------------------------------------------
AutoMySQLBackup – Backing up your SQL db’s!
Hi folks, its been a while since i’ve written anything so I decided to post a quick guide on backing up your MySQL db’s.
To do this we’re going to use a tool called AutoMySQLBackup.
Found here:
http://sourceforge.net/projects/automysqlbackup/
——————————–
Install AutoMySQLBackup
——————————–
For Debian based Linux systems:
apt-get update
apt-get install automysqlbackup
OR
We can download and install manually from their SourceFourge page.
Visit http://sourceforge.net/projects/automysqlbackup/ and grab the latest copy.
I’ll use wget to grab mine and proceed with the install:
mkdir /downloads/automysqlbackup/
cd /downloads/automysqlbackup/
wget http://ufpr.dl.sourceforge.net/proj...ackup VER 3.0/automysqlbackup-v3.0_rc6.tar.gz
tar xzvf automysqlbackup-v3.0_rc6.tar.gz
./install.sh
At the Select the global configuration directory prompt, type the path where the configuration files will be stored.
At the Select directory for the executable prompt, type the path where the program file will be stored.
*NOTE: I use the default paths provided.
*NOTE2: If you use the latter installation method then you will need to install Mutt to be able to send backups via email.
———————————-
Configuring AutoMySQLBackup
———————————-
Edit your myserver.conf located in the configuration directory you specified previously.
pico /etc/automysqlbackup/myserver.conf
To configure basic backup settings, uncomment the following lines in the myserver.conf file, and then change the values to match your own installation:
CONFIG_mysql_dump_username='username'
CONFIG_mysql_dump_password='password'
CONFIG_backup_dir='/home/yourpath/mysqlbackups/'
*NOTE: Make sure you use a MySQL username and password, and not the username and password you use to log in to SSH. Addtionally, make sure that the path you specify for the backup directory exists. AutoMySQLBackup does not automatically create the directory.
To specify specific databases to back up, uncomment following line, and change the value to the databases you want to back up:
CONFIG_db_names=()
*NOTE: By default, AutoMySQLBackup backs up all MySQL databases. You only need to change this setting if you want to back up specific databases.
To specify rotation settings for the different backup intervals, uncomment the following lines, and then change the values to the rotation settings that you want:
CONFIG_rotation_daily=6
CONFIG_rotation_weekly=35
CONFIG_rotation_monthly=150
To send backup files to an e-mail account, uncommentthe following lines, and then modify them as shown. Replace [email protected] with the e-mail address where you want to send the backup files:
CONFIG_mailcontent='files'
CONFIG_mail_address='[email protected]'
————————————
Running Backups
————————————
After you configure AutoMySQLBackup for your environment, you can run backups. To run a backup manually using AutoMySQLBackup, type the following command. Replace path with the path to the myserver.conf file:
automysqlbackup "path/myserver.conf"
If you want to automate this, then you may want to add a CRON entry to do so!
Remember – always make sure to test your backups, you don’t want to have to rely on something that may be flawed. Restore, test, rinse and repeat regularly!
