Ich habe bei mir automysqlbackup laufen.
Code: Alles auswählen
root@ptLWL01:~# cd /etc/default
root@ptLWL01:/etc/default# cat automysqlbackup
# By default, the Debian version of automysqlbackup will use:
# mysqldump --defaults-file=/etc/mysql/debian.cnf
# but you might want to overwrite with a specific user & pass.
# To do this, simply edit bellow.
# Username to access the MySQL server e.g. dbuser
# USERNAME=`grep user /etc/mysql/debian.cnf | tail -n 1 | cut -d"=" -f2 | awk '{print $1}'`
# Username to access the MySQL server e.g. password
# PASSWORD=`grep password /etc/mysql/debian.cnf | tail -n 1 | cut -d"=" -f2 | awk '{print $1}'`
# Host name (or IP address) of MySQL server e.g localhost
DBHOST=localhost
# List of DBNAMES for Daily/Weekly Backup e.g. "DB1 DB2 DB3"
# Note that it's absolutely normal that the db named "mysql" is not in this
# list, as it's added later by the script. See the MDBNAMES directives below
# in this file (advanced options).
# This is ONLY a convenient default, if you don't like it, don't complain
# and write your own.
# The following is a quick hack that will find the names of the databases by
# reading the mysql folder content. Feel free to replace by something else.
# DBNAMES=`find /var/lib/mysql -mindepth 1 -maxdepth 1 -type d | cut -d'/' -f5 | grep -v ^mysql\$ | tr \\\r\\\n ,\ `
# This one does a list of dbs using a MySQL statement.
DBNAMES="ptlwl"
# Backup directory location e.g /backups
# Folders inside this one will be created (daily, weekly, etc.), and the
# subfolders will be database names. Note that backups will be owned by
# root, with Unix rights 0600.
BACKUPDIR="/home/backup"
# Mail setup
# What would you like to be mailed to you?
# - log : send only log file
# - files : send log file and sql files as attachments (see docs)
# - stdout : will simply output the log to the screen if run manually.
# - quiet : Only send logs if an error occurs to the MAILADDR.
MAILCONTENT="log"
# Set the maximum allowed email size in k. (4000 = approx 5MB email [see
# docs])
MAXATTSIZE="400000"
# Email Address to send mail to? (user@domain.com)
MAILADDR="root"
# ============================================================
# === ADVANCED OPTIONS ( Read the doc's below for details )===
#=============================================================
# List of DBBNAMES for Monthly Backups.
MDBNAMES="mysql $DBNAMES"
# List of DBNAMES to EXLUCDE if DBNAMES are set to all (must be in " quotes)
DBEXCLUDE=""
# Include CREATE DATABASE in backup?
CREATE_DATABASE=yes
# Separate backup directory and file for each DB? (yes or no)
SEPDIR=yes
# Which day do you want weekly backups? (1 to 7 where 1 is Monday)
DOWEEKLY=6
# Choose Compression type. (gzip or bzip2)
#COMP=bzip2
# Compress communications between backup server and MySQL server?
COMMCOMP=no
# Additionally keep a copy of the most recent backup in a seperate
# directory.
LATEST=no
# The maximum size of the buffer for client/server communication. e.g. 16MB
# (maximum is 1GB)
MAX_ALLOWED_PACKET=
# For connections to localhost. Sometimes the Unix socket file must be
# specified.
SOCKET=
# Command to run before backups (uncomment to use)
#PREBACKUP="/etc/mysql-backup-pre"
# Command run after backups (uncomment to use)
POSTBACKUP="duply mysqlprofil backup"
root@ptLWL01:/etc/default#Code: Alles auswählen
root@ptLWL01:/etc/default# cd /etc/cron.daily
root@ptLWL01:/etc/cron.daily# cat automysqlbackup
#!/bin/sh
test -x /usr/sbin/automysqlbackup && /usr/sbin/automysqlbackup
root@ptLWL01:/etc/cron.daily#Code: Alles auswählen
root@ptLWL01:/etc/cron.daily# tree /home/backup
/home/backup
├── daily
│ └── ptlwl
│ ├── ptlwl_2011-09-08_00h38m.Donnerstag.sql
│ ├── ptlwl_2011-09-09_00h31m.Freitag.sql
│ ├── ptlwl_2011-09-11_00h41m.Sonntag.sql
│ ├── ptlwl_2011-09-12_00h57m.Montag.sql
│ ├── ptlwl_2011-09-13_00h51m.Dienstag.sql
│ ├── ptlwl_2011-09-13_20h35m.Dienstag.sql
│ ├── ptlwl_2011-09-13_21h29m.Dienstag.sql
│ ├── ptlwl_2011-09-14_00h29m.Mittwoch.sql
│ ├── ptlwl_2011-09-15_00h51m.Donnerstag.sql
│ ├── ptlwl_2011-09-16_00h35m.Freitag.sql
│ ├── ptlwl_2011-09-18_00h48m.Sonntag.sql
│ ├── ptlwl_2011-09-19_00h29m.Montag.sql
│ ├── ptlwl_2011-09-20_00h40m.Dienstag.sql
│ ├── ptlwl_2011-09-21_00h47m.Mittwoch.sql
│ ├── ptlwl_2011-09-22_00h46m.Donnerstag.sql
│ ├── ptlwl_2011-09-23_00h42m.Freitag.sql
│ ├── ptlwl_2011-09-25_00h28m.Sonntag.sql
│ └── ptlwl_2011-09-26_00h52m.Montag.sql
├── ERRORS_localhost-773878490.log
├── localhost-771894965.log
├── monthly
└── weekly
└── ptlwl
├── ptlwl_week.36.2011-09-10_00h48m.sql
├── ptlwl_week.37.2011-09-17_00h39m.sql
└── ptlwl_week.38.2011-09-24_00h54m.sql
5 directories, 23 filesWie zu sehen ist, werden sie das jedoch nicht.
Wo kann der Fehler liegen?
Michael