linuxmanage.com

Backup Script for MySQL DataBases

Below is a good script for creating daily, weekly and monthly backups of your MySQL databases using mysqldump.
It creates separate folders for databases and every dump is in single file (compressed).


AutoMysqlBackup.sh

Original file can be downloaded from:

wget http://sourceforge.net/projects/automysqlbackup/files/AutoMySQLBackup/AutoMySQLBackup%20VER%202.5/automysqlbackup-2.5.1-01.sh

Below is just a copy of that file:

wget http://linuxmanage.com/scripts/12/automysqlbackup-2.5.1-01.sh

Example configuration file

wget http://linuxmanage.com/scripts/12/automysqlbackup.conf.txt

AutoPostgresqlBackup.sh

This is also a very useful script for creating backups of PostgreSQL databases. It works the same like above script for MySQL

Original file can be downloaded from:

wget http://sourceforge.net/projects/autopgsqlbackup/files/AutoPostgreSQLBackup/AutoPostgreSQLBackup-1.0/autopostgresqlbackup.sh.1.0

Below is slightly modified script with some changes like:
- it reads configuration file
- adds data and time for compressed archive

wget http://linuxmanage.com/scripts/12/autopostgresqlbackup.sh.1.1

Configuration file

wget http://linuxmanage.com/scripts/12/autopostgresqlbackup.conf.txt

AutoLDAPBackup.sh

Based on above scripts we created a script for making the LDAP backup.

wget http://linuxmanage.com/scripts/12/autoldapbackup.sh.0.1

Configuration file

wget http://linuxmanage.com/scripts/12/autoldapbackup.conf.txt

If you have any ideas, fixed errors or made some improvements let us know - we will post it here.