[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