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.