mySQL Backup

mySQL-Backup ist ein BackupScript fuer mysql databases

Mit dem script ist es moeglich per cronjob einen automatischen Backup der SQL-databases zu erstellen. Die max. Anzahl der Backups ist einstellbar, nach erreichen von max Backup wird das aelteste Backup geloescht.

 


mySQL-Backup is a backup script for mySQL databases

With this script you can backup your mySQL-databases automatically with a cronjob. You can configure it for your needs. The max. Number of backups can be adjusted, after reaching a maximum, the oldest backup will be deleted.

configuration parameters:

# ————– start configuration ————–#

# tempdir
TDR=/tmp/sql

# destination(backup) dir
DTR=/my_backupdir/goes/here

# how many dumps/DB –> oldest backup will be deleted
MXDP=8

# mySQL
#
# mysql root user
MSQLR=<place root username here>

# mysql root password
MSQLPW=<place (mxsql-)root password here>

# mysql hostname
MSQLHT=localhost

# mysql databases –> delimited with spaces
MSQLDBS=(database1 database2 database3)

 

download the script: <mysql-backup-script.zip 1278 bytes> FREEWARE

Download