[TYPO3-german] Typo3 automatische datenbank sicherung ???

Ivo Engelhardt ivo.engelhardt77 at gmail.com
Thu Jul 7 13:00:04 CEST 2016


Hi,

das ist ein Script was die Aufgabe bei mir erledigt:

#!/bin/bash
# Variablen setzen

BACKUP_DIR=~/html
BACKUP_DEST=~/.tmp_backup

# Konfigurationsdatei finden: localconf.php oder LocalConfiguration.php
CONFIG_FILE=
# TYPO3-Version < 6.0
if [ -f $BACKUP_DIR/typo3conf/localconf.php ]; then

        echo 'TYPO3-Version < 6.0 : localconf.php wird ausgelesen..'

        CONFIG_FILE=$BACKUP_DIR/typo3conf/localconf.php

        DB_NAME=`cat $CONFIG_FILE | grep '\$typo_db\ ' | cut -d "'" -f 2`

 DB_USER=`cat $CONFIG_FILE | grep '\$typo_db_username\ ' | cut -d "'" -f 2`

 DB_PASSWORD=`cat $CONFIG_FILE | grep '\$typo_db_password\ ' | cut -d "'" -f 2`

 DB_HOST=`cat $CONFIG_FILE | grep '\$typo_db_host\ ' | cut -d "'" -f 2`

fi

# TYPO3-Version >= 6.0

if [ -f $BACKUP_DIR/typo3conf/LocalConfiguration.php ]; then

        echo 'TYPO3-Version >= 6.0 : LocalConfiguration.php wird ausgelesen..'

        CONFIG_FILE=$BACKUP_DIR/typo3conf/LocalConfiguration.php

 DB_NAME=`cat $CONFIG_FILE | grep \'database\'\ =\> | cut -d "'" -f 4`

 DB_USER=`cat $CONFIG_FILE | grep \'username\'\ =\> | cut -d "'" -f 4`

 DB_PASSWORD=`cat $CONFIG_FILE | grep \'password\'\ =\> | cut -d "'" -f 4`

 DB_HOST=`cat $CONFIG_FILE | grep \'host\'\ =\> | cut -d "'" -f 4`

fi

if [ -z $CONFIG_FILE ]; then

        echo "TYPO3-Konfiguration nicht gefunden"

fi

mkdir -p  $BACKUP_DEST/$DB_NAME
mysqldump -u $DB_USER -p$DB_PASSWORD -h $DB_HOST $DB_NAME > $BACKUP_DEST/$DB_NAME/database_`date +"%Y.%m.%d-%H:%M"`.sql
tar czf $BACKUP_DEST/$DB_NAME/files_`date +"%Y.%m.%d-%H:%M"`.tar.gz -C $BACKUP_DIR .

Du kannst das ganze auch recht automatisch in ein Google Drive sichern:
http://www.greyboard.net/blog/gdrive-fuer-das-backup-auf-der-konsole-nutzen/

Ivo



More information about the TYPO3-german mailing list