cmsBackup.sh

cmsBackup.sh

# Switch to customer-folder
cd /$PATH/

# Check the current mySQL-Config
cat www/htdocs/system/config/localconfig.php (e.g.)

# Backup MySQL
mysqldump --default-character-set=utf8 --routines -u dbXXXX -p dbXXXX > dbXXXX_YYMMDD_1XX.sql

# Bei Fehler `mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces`
# mysqldump --default-character-set=utf8 --routines -u dbXXXX -p dbXXXX --no-tablespaces > db.sql

# Backup www and/or htdocs
cp -R www www_YYMMDD_1XX

# Backup www and/or htdocs as TGZ (has to contain the mysql-backup!)
tar czf www_mysql_YYMMDD_1XX.tgz www