Make a dump of a TYPO3 installation

t3dump.sh

#!/bin/sh

# Project infos
PROJECT_NAME=foobar
DOCUMENT_ROOT=htdocs

# Database access
DB_USERNAME=foo
DB_PASSWORD=bar
DB_DATABASE=foobar
DB_HOST=localhost

################################################################################

# Current timestamp
TIMESTAMP=`date +%Y%m%d%H%M%S`

# Clean up
find . -name '.DS_Store' -exec rm -f {} \;
rm -f $DOCUMENT_ROOT/typo3conf/temp_*  2> /dev/null

# Make database dump
mysqldump -u $DB_USERNAME -h $DB_HOST $DB_DATABASE -p$DB_PASSWORD > $PROJECT_NAME.sql
gzip $PROJECT_NAME.sql

# Pack up project
tar zcfp ${PROJECT_NAME}_${TIMESTAMP}.tar.gz --exclude $DOCUMENT_ROOT/typo3temp/tx_ncstaticfilecache $DOCUMENT_ROOT/ typo3_src-*/ $PROJECT_NAME.sql.gz scheduler.sh
rm -f $PROJECT_NAME.sql.gz